YOU’VE BEEN INVESTIGATING DEADLOCKS ON YOUR SERVER USING TRACE FLA...

14. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P28 PDF
THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P28 PDF
14. You’ve been investigating deadlocks on your server using trace flag 1222, and you’d like to enable it permanently to capture extra information if deadlocks occur again, even if SQL Server gets restarted. What is the easiest way to do this?A. Execute DBCC TRACEON (1222,-1)B. Create a startup stored procedure containing DBCC TRACEON (1222,-1) and use sp_configure to enable scan for startup procsC. Use Configuration Manager to add –T1222 as a startup parameter for the SQL Server serviceD. Execute DBCC TRACEON (1222)