Post reply

Triggers Not Found at Subscriber End

  • April 22, 2014 at 12:04 am

    #306892

    Dear,

    I have configured snapshot replication in my database. Some of my tables have triggers. But at the subscriber end, I have not found triggers associated with those tables.

    Please let me know how to keep triggers available at subscriber end after replication is done.

    Thanks

    Akbar

  • April 22, 2014 at 6:34 am

    #1707724

    Open the properties of your publication, go to articles, select your table, click on the button "Article properties", select "set properties of highlighted article". With the properties change the value for "Copy user triggers" to true.

    MCITP SQL 2005, MCSA SQL 2012

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

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