Re: How can I find out information about process based on spid?

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 15:22:59 -0400

take a look at DBCC INPUTBUFFER() and fn_get_sql in BooksOnLine. 

-- 
Andrew J. Kelly  SQL MVP
"peja" <anonymous@discussions.microsoft.com> wrote in message
news:9d6601c49768$c292cc90$a601280a@phx.gbl...
> Hi,
> sometimes I cannot connect to the server using enterprise
> manager because server is too busy, but I'm able to
> execute sp_who2 from query analyzer...
> This stored procedure provides me with the list of spids
> on the system, but it doesn't help me with what each of
> these processes actually is. For example, I cannot see the
> text of currently executed statement, like I'm able to see
> using EM (Current Activity).
> Is there any way (stored procedure with spid as a
> parameter, or query against some system table) which
> provides this info?
> Thanks,
> Peja