DBCC InputBuffer (spid)

Stephen Dyckes



-----Original Message-----
From: Keith Taylor <mssqldba-ezmlmshield-x4504244.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Wed Apr 30 16:30:34 2008
Subject: Run-away processes...

I thought someone on here posted a DBCC command a while back that would
show you the SQL behind a given SPID.



I'm having trouble finding what the DBCC command was for that... I
remember something about 'cache' in the name or 'proc' in the name...





Thanks!





Keith Taylor

American Animal Hospital Association

DBA/Applications Analyst

keith.[Email address protected]

720-963-4400





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



-----------------------------------------
The information contained in this e-mail message is intended only
for the personal and confidential use of the recipient(s) named
above. This message may be an attorney-client communication and/or
work product and as such is privileged and confidential. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are
hereby notified that you have received this document in error and
that any review, dissemination, distribution, or copying of this
message is strictly prohibited. If you have received this
communication in error, please notify us immediately by e-mail, and
delete the original message.

MS Sql Server LazyDBA home page