Thanks to all who responded. The responses were helpful and varied.

~ Joshua

When I run what you provided, I do in fact get results. The text column contains the 3 statements that I ran to get the results in the first...

This is what I have done:

DBCC TRACEON(2861)

DECLARE @HANDLE BINARY(20)

SELECT @HANDLE = sql_handle from dbo.sysprocesses where spid = 55

SELECT text FROM ::fn_get_sql(@handle)

Am I supposed to run this from master? If...

When I use dbo.sysprocesses with my current database, I still get an error saying Invalid object name. If I use 'master' database, I get result with no rows. ...

Mayank,

Thank you for the reply. When I run the statement I get an error:

Invalid object name 'sys.sysprocesses'.

I am using SQL Server 2000. I am quite new to triggers...