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...
PlanetJam Media Group
March 28, 2003 at 9:15 am
Do a SELECT with a WHILE loop.
PlanetJam Media Group
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...
PlanetJam Media Group
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 ...
PlanetJam Media Group
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
PlanetJam Media Group
September 4, 2001 at 7:50 am
Viewing 5 posts - 1 through 5 (of 5 total)