I have a Master File table on a server(A). Data is first replicated to a central server(B) and then to all of our locations(C). Then from C->B->A
A = Sql 2005 B = SQL 2005 C = Sql 2000
My issue is that data gets all the way to C but replication is set for updates yet I get a Primary Constraint error from C -> B. I set loopback detection on SQL 2000 servers to 1 so that it does not send. However I still get the error. How can I fix this?
What i did to fix this issue is I manually created a type of 'system stored procedure'(Ms_ins) and i gave it the same parameters the system insert stored procedure that was causing me the problems had. I then dropped my article and added it again(to prevent reinitialization of the publication), and then I changed the insert stored procedure in the articles properties to the new stored procedure I created(again, this SP does nothing. I just contains the params). This worked in all situations. Thanks for nothing on this one guys!