for SQL 2005 run

DBCC TRACEON (1204, -1)

DBCC TRACEON (1222, -1)

-- to check the status

DBCC TRACESTATUS(-1)

for more information please check BOL.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2ed3e3e7-5080-4fa3-b79a-585470602bc2.htm