harim
SSC Enthusiast
Points: 128
More actions
January 7, 2003 at 3:29 pm
#79978
Is there a way I can still perform Transaction Replication. Any way to get around the fact of not being able to use auto-generated ids?
Thanks.
Andy Warren
SSC Guru
Points: 119902
January 7, 2003 at 3:34 pm
#445796
You have to have a primary key, not an identity col. You can use a natural key, identity of course, a uniqueidentifier along with newid().
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndyConnect with me on LinkedIn
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply