CODEWITHSUNDEEP
sql-serversql-server-2005triggers
Jeff
Jeff

Reputation: 36573

SQL Server Triggers and Replication

I have a trigger on update of a table that inserts into another table. This other table only exists in one location (the table is not replicated). If I set the trigger as not for replication, will my update trigger still fire when replicated data comes in to the table with the trigger? That way I can have the trigger and the tables that it inserts into in only one location.

Upvotes: 0

Views: 4725

Answers (1)

gbn
gbn

Reputation: 432471

No: this is the point of NOT FOR REPLICATION. From MSDN

  • Triggers

The trigger is not executed when a replication agent performs an insert, update, or delete operation.

The key here is "replication agent": this is the process that makes the trigger not fire

Upvotes: 3

Related Questions