oracleSQLdba
IS-IT--Management
does anyone know if deadlocks are reported in the sql 2000 error log by default?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Deadlocking 1
- Thread starter oracleSQLdba
- Start date
- Status
-
1
- #2
ptheriault
IS-IT--Management
No there are not. You have to enable the trace flag -T1204 : )
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Thread starter
- #3
oracleSQLdba
IS-IT--Management
Wow....that saved me a lot of homework.... THANKS!!!!!
ptheriault
IS-IT--Management
No problem, I know you Oralce guys don't get to touch SQL Server much! ; )
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Thread starter
- #5
oracleSQLdba
IS-IT--Management
Funny thing is, I still get a paycheck every week : )
- Status