Friday, March 23, 2012

Replication Question

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.

No comments:

Post a Comment