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




MS Sql Server LazyDBA home page