thaburner
asked on
SQL Server 2012 - Merge Replication Issue
I have setup Replication Merge between two servers. The sync works just fine, entering all the tables and the first four Stored Procedures. However soon as it hits this stored procedure, it dies every time. The stored procedure works with our Windows Application without any issues. I'm just not sure what is going on that it doesn't like.
This is the error message: MSSQL_REPL-2147201001
This is the error message: MSSQL_REPL-2147201001
USE [Engineering_Timesheet]
GO
/****** Object: StoredProcedure [dbo].[ispCreatePTAssignedSubProject] Script Date: 2/7/2017 6:41:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ispCreatePTAssignedSubProject]
@subprojectid int,
@employeeid int,
@deleted bit
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO
[PTAssignedSubProject] (SubProjectID, EmployeeID,Deleted, rowguid)
VALUES
(
@subprojectid,
@employeeid,
@deleted,
newid()
)
SELECT SCOPE_IDENTITY() AS PTAssignedSubProjectID
END
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.