Re: SPID question
From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 02/21/05
- Next message: Paul Ibison: "SPID question"
- Previous message: Paul Ibison: "Performance Counters for Replication"
- In reply to: Brad Feaker: "SPID question"
- Next in thread: Paul Ibison: "SPID question"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 21 Feb 2005 12:26:32 -0500
Transactional replication does not fire triggers. Are you perhaps thinking
of queued or immediate updating? Queued does use triggers which do use the
same SPID. Immediate Updating uses MSDTC to apply the transaction on the
publisher. I am not sure if the context would be the same spid, but triggers
are not involved.
-- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Brad Feaker" <BradFeaker@discussions.microsoft.com> wrote in message news:C5766E15-A548-45BD-ADCC-35EAB6F46FC5@microsoft.com... > 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 >
- Next message: Paul Ibison: "SPID question"
- Previous message: Paul Ibison: "Performance Counters for Replication"
- In reply to: Brad Feaker: "SPID question"
- Next in thread: Paul Ibison: "SPID question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
