Post reply

Unable to replicate in SQL Server 2000 using Transactional Replication

  • September 27, 2012 at 12:40 am

    #393264

    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.

  • September 27, 2012 at 10:26 pm

    #1543176

    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

  • September 29, 2012 at 12:32 am

    #1543673

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply