Based on this Troubleshoot a process (SPID) using tools & TSQL queries blog post I have been asked to provide same information within SQL Server 2000 version, as that talks about SQL 2005 version specific. Within SQL 2000 to troubleshoot further about a SPID you can use: DECLARE @Handle binary(20) SELECT @Handle = sql_handle FROM sysprocesses WHERE spid = <spid> SELECT * FROM ::fn_get_sql(@Handle)...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/08/20/dig-further-for-a-process-spid-using-query-analyzer-sql-2000-version-specific-not-dbcc-inputbuffer-though.aspx