Unable to replicate in SQL Server 2000 using Transactional Replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » Unable to replicate in SQL Server 2000 using...

Unable to replicate in SQL Server 2000 using Transactional Replication

Rate Topic

Display Mode

Topic Options

Author

Message

shohelr2003

Posted Thursday, September 27, 2012 12:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:32 AM
Points: 124, Visits: 324

1. My database consists of 397 tables. Platform is SQL Server 2000 Enterprise Edition

2. While creating a publication using transactional replication, I get most of the tables are crossed mark. So I can not select required tables. But if I use snapshot replication, there is no such problem. I can select all of the tables. I am not getting the reason. Please let me know where is the problem.

Post #1365052

happycat59

Posted Thursday, September 27, 2012 10:26 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:55 PM
Points: 2,471, Visits: 2,066

For a table to be used in transactional replication it must have a primary key (a unique constraint is not enough). This is, most likely, the cause of your problem

Post #1365595

shohelr2003

Posted Saturday, September 29, 2012 12:32 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:32 AM
Points: 124, Visits: 324

Thank you for your reply. I got the point. That's the reason.

Post #1366165

« Prev Topic | Next Topic »

Permissions