Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to replicate in SQL Server 2000 using Transactional Replication Expand / Collapse
Author
Message
Posted Thursday, September 27, 2012 12:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:17 AM
Points: 203, Visits: 499
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
Posted Thursday, September 27, 2012 10:26 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:16 PM
Points: 2,922, Visits: 2,521
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
Posted Saturday, September 29, 2012 12:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:17 AM
Points: 203, Visits: 499
Thank you for your reply. I got the point. That's the reason.
Post #1366165
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse