sql server transactional Replication

  • 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 .

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

  • 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 ?

  • 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