Link to home
Start Free TrialLog in
Avatar of thaburner
thaburnerFlag for United States of America

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

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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of thaburner
thaburner
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial