Snippets of the day – Sunday, January 5, 2014

Posted on Leave a commentPosted in Snippets

Here are some of the most recently published snippets! Detect and received deadlock info on SQL Server The first requirement is to turn on the appropriate Trace Flags: DBCC TRACEON (3605,1204,1222,-1) The second requirement is to ensure you have DB Mail setup and working (optional). Many thanks to Geoff Albin: http://www.sqlservercentral.com/articles/deadlock/71374/ Open the snippet Author: […]