SQL Server Performance Forum – Threads Archive

Getting Procedure/Table names using SPID

Hi Guys, Is there a way i can get the stored procedures/tables involved in the deadlock chain below using the SPID since it’s not showing in the texdata column or is there s’thing i lef out Thanks. Event Class EventSubClass TextData SQLTransaction Begin Lock:Acquired2006-05-22 17:17:47.707 SQLTransaction2006-05-22 17:17:47.707 Commit Lock<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />eadlock Chain 101Deadlock Chain SPID = 64 Lock<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />eadlock Chain 101Deadlock Chain SPID = 62 Lock<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />eadlock Chain 101Deadlock Chain SPID = 60 Lock<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />eadlock Chain 101Deadlock Chain SPID = 62 Lock<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />eadlock Chain 101Deadlock Chain SPID = 53 Lock<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />eadlock Chain

Learn how to avoid Deadlocks
http://sql-server-performance.com/deadlocks.asp
Madhivanan Failing to plan is Planning to fail

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q169960&
http://www.devx.com/DevX/Link/16486 —————————————-
http://dineshasanka.blogspot.com/

http://www.developer.com/db/article.php/10920_3490086_2 to use the PROFILER to cpature more information in this regard. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for the links pple.What i wanted to know is the stored procedures and tables involved using SPID.so that i can now resolve the issue.

Then … check with Profiler. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>