DBCC inputbuffer(SPID)

example DBCC inputbuffer(88)


-----Original Message-----
From: Keith Taylor
[mailto:mssqldba-ezmlmshield-x4504244.[Email address protected]
Sent: Wednesday, April 30, 2008 4:31 PM
To: LazyDBA Discussion
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 and any of its
attachments is intended only for the use of the address(es)
indicated above, and is confidential. This information may
also be legally privileged. If you are not the intended
recipient(s), you are hereby notified that any dissemination,
review or use of the information contained herein is
strictly prohibited. You may not copy, forward, disclose or use
any part of this information. If you have received this
information in error, please delete it and all copies from your
system and notify the sender immediately by return E-mail.

Thank you.

Internet communications are not always timely or
secure, and can contain errors and viruses. The sender does not
accept liability for any errors or omissions which arise as a
result.
****************************************************************

MS Sql Server LazyDBA home page