Home Forums SQL Server 2008 SQL Server 2008 - General SQL Server 2008 R2 Merge Replication IDENTITY field issues RE: SQL Server 2008 R2 Merge Replication IDENTITY field issues
henners72
SSC Eights!
Points: 884
More actions
May 23, 2011 at 3:41 pm
#1328752
If the table is duly ever updated I would suggest removing the identity and adding a trigger to assign the pk for inserts. Easy fix but not recommended on tables with alot of activity.