Dig further for a process (SPID) using Query Analyzer (SQL 2000 version specific) not DBCC INPUTBUFFER though.

Based on this Troubleshoot a process (SPID) using tools &amp; 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 = &lt;spid&gt; SELECT * FROM ::fn_get_sql(@Handle)...(<a href="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">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1580" width="1" height="1">