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

From: peja (anonymous_at_discussions.microsoft.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 12:02:46 -0700

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

Relevant Pages

  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: ADO.NET 2.0 Asynchronous Command Execution: Independant of Web Session?
    ... i can execute a simple SP ... If this is SQL Server, perhaps you can set up a SQL Agent job and kick it ... off with the sp_start_job stored procedure. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Weird SqlDataReader: Invalid attempt to read when no data is present.
    ... When I execute the stored ... I know my stored procedure is working ok. ... > the SQL Query analyser and got results. ... The data reader object's HasRows ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Action pass-through with a form variable Access 2003
    ... variables don't exist on the server where it will execute. ... You can use variables in a regular query that will first be processed by the ... Jet or ACCDB database engine before being handed over to the ODBC driver. ...
    (comp.databases.ms-access)
  • Re: [PHP] how to curl
    ... i have a few questions as well; is the query being executed on the provider ... consumer (the one you intend to execute the curl request from)? ... Yes I'm doing on the both the server. ... And when a consumer server will send ...
    (php.general)