SQL Server 2000 SP2 and Deadlock Reporting Problem Not Fixed? 
Author Message
 SQL Server 2000 SP2 and Deadlock Reporting Problem Not Fixed?

It was reported that SQL Server 2000 SP2 (which we have installed and
tested) was supposed to address incorrect reporting of deadlocks by the
Profiler (see FIX: Deadlock Information Reported with SQL Server 2000
Profiler Is Incorrect (Q282749) at
http://www.***.com/ ;EN-US;q282749&GSSNB=1)

We have tested this from both SP1 and SP2 clients against our SP2 server,
but still experience the same old problems.

Can anyone else verify the problem (you can easily see the problem in
Profiler if you only see 2 DeadlockChain events and one of the SPIDs is

Thanks to anyone who can check this.


Sat, 22 May 2004 04:21:22 GMT
 [ 1 post ] 

 Relevant Pages 

1. SQL 2000 Bogus rollbacks NOT fixed with SP2

2. MS SQL 2000 - Version not reflecting post SP2 SQL2000 fixes

3. Deadlock and NOLOCK (SQL Server 2000, SP2)

4. Hot Fixes Post-SP2 for SQL Server 2000

5. Linked Server to Analysis Services does not work (SQL Server 2000, SP2)

6. Connecting to a Sql Server 2000 SP3 from a Sql Server 2000 SP2

7. SQLMail not working after installing sp2 for sql server 2000

8. SQL 2000 w/ Sp2 not properly launching the server properties tab

9. Installing Sql Server 2000 - SP2 (Problems)

10. MS SQL Server 2000 SP2 AV problem with pwdencrypt: possible buffer overflow

11. Problems with Enterprise Manager in SQL Server 2000 SP2

12. SQL Server 7 SP2 Install Problem with Windows 2000 Pro

Powered by phpBB® Forum Software