sql server replication: Trigger and replication -- sql server replication

Trigger and replication

swati
11/30/2004 11:37:52 AM

sql server replication:
I have set up the transactional replication with Qued option ..
I have a trigger on one of the table which inserts the data in another
tables after insert /update activity happens . I have set up the trigger
with Not for replication
but still the trigger is fired twice without any interval .. and making the
data available in twice

How should I go for it ??

Regards,
Swati

Re: Trigger and replication

Vijay [MSFT]
11/30/2004 12:55:39 PM

If the trigger is on subscriber, the user trigger needs to call
sp_check_for_sync_trigger and skip processing when the it is called on the
context of the Queued trigger.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
OR if you wish to include a script sample in your post please add "Use of
included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"

[quoted text, click to view]