Friday, 25 March 2011

Tracing deadlocks in SQL Server
Found that these three dbcc traceon calls worked for us in SQL 2008
DBCC TRACEON (1222, -1)

Then check the SQL logs to see exactly what is causing the dead lock to occur

No comments:

Post a Comment

How to by pass the Jaguary X-Type enter security pin screen after changing battery

How to bypass security code on Jaguar X-Type touchscreen Satellite Navigational units. Just hold the skip track, AMEM and PTY buttons ...