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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 07, 2014 4:55 AM
Points: 175, Visits: 470
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 @ 9:23 PM
Points: 2,841, Visits: 2,422
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 07, 2014 4:55 AM
Points: 175, Visits: 470
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