Home Forums SQL Server 2005 Administering catch a sql server timeout exception RE: catch a sql server timeout exception
ChiragNS
One Orange Chip
Points: 26137
More actions
August 5, 2009 at 7:27 am
#1034761
Create a trace, put the output of the trace in a file and run the trace. This is uses lesser resources than running the trace on profiler. Also set the DBCC Traceon statement to record any deadlock information on the SQL logs.
"Keep Trying"