Viewing 5 posts - 1 through 5 (of 5 total)
Whenever your server is started run:
DBCC TRACEON(1204,3605,-1)
This will put all the details that caused the deadlock into your SQL Server Logs, including the SP's and line numbers that caused it.
PlanetJam...
March 28, 2003 at 9:15 am
Do a SELECT with a WHILE loop.
PlanetJam Media Group
December 19, 2002 at 6:43 am
We just scaled-up our db server, and went to 4 1.6 ghz processors (up from 750 mhz) with 8 gigs RAM (up from 4)
I did both PAE and 3GB and...
December 12, 2002 at 8:15 am
Unfortunately, I was on the phone with MS Support Friday hunting this. The actual syntax per MS is:
DBCC TRACEON(1204,3605,-1)
1204 = Trace Deadlocks
3605 = Write to Server Log file
-1 ...
November 18, 2002 at 7:14 am
This is ludicrous...the same thing can be accomplished without the use of a cursor.
PlanetJam Media Group
September 4, 2001 at 7:50 am
Viewing 5 posts - 1 through 5 (of 5 total)