How to determine the name of a process that caused a trigger to fire

Short Version: Does anyone know of a way --inside a SQL 2000 trigger-- of detecting which process modified the data, and exiting the trigger if a particular process is detected?

Long Version I have a customized synchronization routine that moves data back and forth between dis-similar database schemas.

When this process grabs a modified record from Database A, it needs to transform it into a record that goes into Database B. The database are radically different, but share som开发者_如何学Goe of the same data such as user accounts and user activity (however even these tables are structurally different).

When data is modified in one of the pertinent tables, a trigger fires which writes the PK of that record to a "sync" table. This "sync" table is monitored by a process (a stored proc) which will grab the PK's in sequence, and copy over the related data from database A to database B, making transformations as necessary.

Both databases have triggers that fire and copy the PK to the sync table, however these triggers must ignore the sync process itself so as not to enter into "endless" loop (or less, depending on nesting limits).

In SQL 2005 and up, I use the following code in the Sync process to identify itself:

SET CONTEXT_INFO 0xHexValueOfProcName

Each trigger has the following code at the beginning, to see if the process that modified the data is the sync process itself:

IF (CONTEXT_INFO() = 0xHexValueOfProcName)
BEGIN
--  print '## Process Sync Queue detected. This trigger is exiting! ##'
  return
END

This system works great, keep chugging along, keeps the data in sync. The problem now however is that a SQL2000 server wants to join the party.

Does anyone know of a way --inside a SQL 2000 trigger-- of detecting which process modified the data, and exiting the trigger if a particular process is detected?

Thanks guys!

(As per Andriy's request, I am answering my own question.)

I put this at the top of my trigger, works like a charm.

-- How to check context info in SQL 2000
IF ((select CONTEXT_INFO from master..sysprocesses where spid = @@SPID) = 0xHexValueOfProcName)
BEGIN
  print 'Sync Process Detected  --  Exiting!'
  return
END