SPID question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 09:43:01 -0800

If you're talking about immediate/queued updating
subscribers, then it is not the replication process that
initiates the trigger firing - it is a user insert. Data
for immediate updating subscribers forms part of a 2PC
transaction and cannot be treated later on.

Although InsteadOf triggers might be considered, data
going into the immediate update/queue should not really
be prioritized in a different order, as this might break
the transactional consistency - however this would be a
way to achieve your aim.

Rgds,
  Paul Ibison SQL Server MVP, www.replicationanswers.com
  (recommended sql server 2000 replication book:
  http://www.nwsu.com/0974973602p.html)