SPID question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Brad Feaker (BradFeaker_at_discussions.microsoft.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 08:41:08 -0800

When transactional replication fires an insert trigger on the subscriber
server/database/table, does the trigger run under the same spid as the
replication process that fires it? Strange question, I know, but I have to
modify an insert trigger to fire only if the table has a row inserted from
the OLTP application and to capture the inserted data from replication and
process it at a later time. I know this is a strange way to process, but
this is what the client wants...Any suggestions appreciated.

Regards,

Brad Feaker 

-- 
Brad Feaker

Relevant Pages

  • Re: Replication ntext only by UPDATE
    ... I understand that you have to have a trigger that fires on insert, ... Looking for a SQL Server replication book? ... > ntext column). ...
    (microsoft.public.sqlserver.replication)
  • Re: Triggers and Merge replication
    ... Merge replication does not allow ping-pong movement of data by design. ... If you insert data into publisher, then your trigger fires and inserts ... > I have a database that is replicated between 3 SQL servers ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication conflict
    ... I think the trigger should look like this ... FOR INSERT, UPDATE NOT FOR REPLICATION ... is removing the domain name, whereas this will perform better for you. ... between sync's you will have a conflict. ...
    (microsoft.public.sqlserver.replication)
  • Re: Complicated Merge Replication/Trigger problem
    ... tracking Im going to cause a conflict as far as I understand it? ... After making the changes on the publisher ... and 1 upload is showing in replication monitor. ... Curiously when I disabled the trigger and made the ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication conflict
    ... First off I think your trigger is incorrect. ... It is only good for singleton ... FOR INSERT, UPDATE NOT FOR REPLICATION ... between sync's you will have a conflict. ...
    (microsoft.public.sqlserver.replication)