Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-08-01 : 10:25:42
|
| I have a table that is being replicated. Each time the table is updated a trigger is fired locally that inserts the updated row into an archive table.Changes made to the main table are successfully being replicated to the subscriber, however the trigger is not being fired on the subscriber side.I don't understand why this is? The trigger doesn't have 'NOT FOR REPLICATION' set, so it should be firing on the subscriber side.I've also done a test where I make an update on the subscriber side and the trigger fires successfully there. |
|
|
|
|
|
Replication triggers not firing