How to determine the name of a process that caused a trigger to fire
SET CONTEXT_INFO exists for SQL Server 2000 too.

However, you have to query sysprocesses.context_info to read it back. CONTEXT_INFO() was new for SQL Server 2005.