Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 determine params of blocking proc

Author  Topic 

influent
Constraint Violating Yak Guru

367 Posts

Posted - 2010-04-22 : 15:38:46
Is there a way to determine the parameters of a stored procedure that is blocking? Activity Monitor doesn't tell me, it only tells me the proc name, and I can't run Profiler all day for something that happens once a year.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-22 : 15:41:37
Run DBCC INPUTBUFFER(spidNo).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -