Post reply

sql server transactional Replication

  • June 6, 2013 at 10:02 am

    #278299

    We are running SQL Server Transactional Replication and we selected a few tables to be replicated. One of the tables has 3 triggers defined on it an d when we run the snapshot, this table is not created . It is selected to be replicated and it has a Primary Key . Any ideas ? I am a bit desperate .

  • June 6, 2013 at 10:24 am

    #1621828

    Have you checked the log of the snapshot agent (SQL Agent Job)?

  • June 6, 2013 at 10:27 am

    #1621832

    Thank you for the feedback. I forgot to add that the Primary Key is an identity column with the Setting NOT FOR REPLICATION enabled . Is there a workaround ?

  • June 7, 2013 at 8:23 am

    #1622086

    The identity column should not be the problem. The table on the subscriber is created using the usual create-table-statement.

    As arnipetursson already mentioned: check the snapshot agent for error messages.

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

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