Hi all,
I am seting up a Publisher in SQL 2000.
When I get to the screen to specify Articles after selecting a transactional replication, most of my tables are unselectable. In fact out of 25 tables only one is selectable. The rest have a key with an x next to them. Why would that be?Hi again,
I went ahead and started a replication as merge replication. But now when I created a Pull Subscriber, the job failed with the following:
Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script '\\NJRARSVR00E9\d$\sqldata\system\MSSQL$P001\ReplD ata\unc\NJRARSVR00E9$P001_PTR_PTR Merge\20040106110922\tblUser_1.sch' could not be propagated to the subscriber.
What does this mean?|||Do you have a primary key for each of those 25 tables?|||I do not. I have a primary key on some, but not all.|||You can't do transactional replication on tables tat do not have primary keys.
Try adding primary keys into your table again before doing it.
Showing posts with label selecting. Show all posts
Showing posts with label selecting. Show all posts
Friday, March 23, 2012
Replication Question
Subscribe to:
Posts (Atom)