Is there a way to view the "Process Details/Last TSQL command batch" for a
given SPID from Query Analyser? In EM if you go to > Managment > Current
Activity > Process Info > and then double click on a SPID, you can view the
Process Details/Last TSQL command batch.
From QA I would like to be able see the same info by running a SPROC like
"sp_SPID_Details(51)". I know that SPROC doesn't exist, but is there
something similar?eHi
You could try DBCC INPUTBUFFER to get some information back. See Books
online for more.
John
"Dan" wrote:
> Is there a way to view the "Process Details/Last TSQL command batch" for a
> given SPID from Query Analyser? In EM if you go to > Managment > Current
> Activity > Process Info > and then double click on a SPID, you can view the
> Process Details/Last TSQL command batch.
> From QA I would like to be able see the same info by running a SPROC like
> "sp_SPID_Details(51)". I know that SPROC doesn't exist, but is there
> something similar?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment