Tac11 (4/28/2015)
when I run your query on my laptop getting this error:Msg 9436, Level 16, State 1, Line 7
XML parsing: line 5, character 15, end tag does not match start tag
What is your build number for SQL Server from SELECT @@VERSION? You are hitting a bug in the xml_deadlock_report XML output that was fixed and you are really behind on patching if you are getting that error:
https://support.microsoft.com/en-us/kb/978629
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]