December 31, 2001 at 1:39 pm
Playing with updatable subscriptions, I've found an odd thing:
It seems I have to alter my existing triggers to exit if they are fired by the repilcation trigger. Is this so? I have a lot of triggers that my users are gun-shy about altering and maintaining. How can I get 2-way replication without changing my existing and future triggers?
Thanks,
Jerry Ratner
December 31, 2001 at 2:29 pm
When triggers are built (or altered), you can include the following: NOT FOR REPLICATION.
As per Books Online:
quote:
NOT FOR REPLICATIONIndicates that the trigger should not be executed when a replication process modifies the table involved in the trigger.
Otherwise their firing is the proper behavior. You probably are going to have to go back and alter your triggers, but at least you're not having to massively rewrite a bunch of code.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply