April 8, 2005 at 10:28 am
Database snapshot replication is setup to several other instances around the world.
Publisher db has:
select replinfo
from sysobjects
where xtype = 'U'
Returns "3".
select replinfo
from sysobjects
where xtype = 'PK'
Returns "0"
Why are my PK not being replicated and how do I setup/fix?
The PK is setup as an identity(1,1) type and want this replicated also.
Any reason not to do this?
Thank you
Randy
April 8, 2005 at 10:37 am
Is the PK IDENTITY set-up as IDENTITY = YES OR IDENTITY = YES (For Replication)??
Good Hunting!
AJ Ahrens
webmaster@kritter.net
April 8, 2005 at 11:01 am
I see options for "No", "Yes" and "Yes (Not For Replication)". The "Yes" is used.
Randy
April 8, 2005 at 11:34 am
April 8, 2005 at 12:50 pm
Great article. It appears that identity & PK are not replicated by default. If I understood correctly the author created the identity & PK manually on the subscriber and then modified the replication procedures to include the identity & PK when replicating.
Thank you
Randy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply