I'm running a Stored Procedure and I get this error:
The Stored Procedure Resolver encountered the following error executing the stored procedure 'dbo.test_Resolver_Conflict'. Explicit value must be specified for identity column in table 'myTable' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.
When I change a value on the same column in Publisher and Subscriber and then run the Replication Job, I want to duplicate the ROW with a Stored Procedure Resolver. It runs this query:
INSERT INTO myTable (name, value) SELECT name , value FROM myTable WHERE rowguid = @rowguid
myTable Creation:
CREATE TABLE myTable( id identity , name varchar , value int )
Merge Replication creates rowguid automaticaly.