SQL Server Performance

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

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 20, 2007.

  1. Anonymous New Member

    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">

Share This Page