June 6, 2013 at 10:02 am
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
Have you checked the log of the snapshot agent (SQL Agent Job)?
June 6, 2013 at 10:27 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy