By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Triggers and Replication

P: n/a
If a table is updated via replication, will an INSERT trigger go off if
a new row is being added?

--Bob

Jul 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"drpepper" <bc******@gmail.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
If a table is updated via replication, will an INSERT trigger go off if
a new row is being added?

--Bob


See CREATE TRIGGER in Books Online - if the trigger was created NOT FOR
REPLICATION, then no, otherwise yes.

Simon
Jul 23 '05 #2

P: n/a
That's what I thought, but my trigger is not firing....

Jul 23 '05 #3

P: n/a

"drpepper" <bc******@gmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
That's what I thought, but my trigger is not firing....
"You sure?"

The reason I ask is all to often folks will write a trigger assuming it
fires for every ROW updated/inserted/deleted.

It doesn't. It fires once per batch. So it's quire possible it's firing
for your replication statement, but only performing its action on one row
and you're not noticing.


Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.