Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Triggers Not Found at Subscriber End Expand / Collapse
Author
Message
Posted Tuesday, April 22, 2014 12:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
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
Post #1563688
Posted Tuesday, April 22, 2014 6:34 AM This worked for the OP Answer marked as solution
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:59 AM
Points: 304, Visits: 574
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
Post #1563813
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse