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.
| Author |
Topic |
|
AparajitaDutta
Starting Member
1 Post |
 Posted - 2012-09-14 : 06:52:53
|
| How to write query to get all data that are being collected as deadlocks in SQL server, i am not allowed to use SQLtrace. Anyone help is highly appreciated. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-14 : 07:06:25
|
| As far as I know, in SQL 2005 there isn't a way to do this without SQL Trace permissions. If you are fortunate enough to be on SQL 2008, see this article by Jonathan Kehayias that describes how to use extended events to get deadlock graphs: http://www.sqlservercentral.com/articles/deadlock/65658/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
Deadlocks in SQL server