Wednesday, June 13, 2012 10:06 PM
I am using SQL Server 2008 r2.
I am having Deadlock problem when process usually executes a stored procedures. i want to know which specific queries are creating deadlock.
Could you please inform me any script or an easy way through which I can do it?
Wednesday, June 13, 2012 11:53 PM
Another one with a trace flag option. Normally such flags are not kept on for an extended on a server. Just long enough to gather the required info and then turned off.
Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.
Aalam | Blog (http://aalamrangi.wordpress.com)
Monday, June 25, 2012 3:12 PM
SQL Server Profiler has a Deadlock event. Trace while the ddealock is occuring and you can view the statements involved.
Jack Vamvas sqlserver-dba.com