Microsoft Exam Questions

You need to capture the deadlock information to the SQL Server error log

You configure a SQL Server 2008 instance that contains a database named Customers. The
Customers database experiences deadlock problems.
You need to capture the deadlock information to the SQL Server error log.
What should you do?

A.
Enable file system auditing.

B.
Enable the Windows Event Collector service.

C.
Configure trace flags and then restart the SQL Server instance.

D.
Configure a Data Collector Set and then restart the SQL Server instance.