You are the database administrator of your company. The network contains a SQL Server 2008 computer thathas 15 databases. Users report that some queries take a long time to complete. You investigate and discoverdeadlocks are causing this problem.
You want to receive information about the resources and types of locks that are causing deadlocks along with thecurrent command affected by the deadlocks.
You want to receive this information in Extensible Markup Language(XML) format.
Which Transact-SQL statement should you run?