Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesAnyone know why this happens when the SQL Server 2000 is just starting up? Is it unavoidable? Deadlock encountered .... Printing deadlock information 2006-11-29 12:09:21.74 spid3 2006-11-29 12:09:21.74 spid3 Wait-for graph 2006-11-29 12:09:21.74 spid3 2006-11-29 12:09:21.74 spid3 Node:1 2006-11-29 12:09:21.74 spid3 DB: 94 CleanCnt:1 Mode: X Flags: 0x0 2006-11-29 12:09:21.74 spid3 Grant List 0:: 2006-11-29 12:09:21.74 spid3 Owner:0x5430fac0 Mode: X Flg:0x0 Ref:2 Life:00000000 SPID:578 ECID:0 2006-11-29 12:09:21.74 spid3 SPID: 578 ECID: 0 Statement Type: SELECT Line #: 17 2006-11-29 12:09:21.74 spid3 Input Buf: Language Event: master.dbo.sp_MShasdbaccess 2006-11-29 12:09:21.74 spid3 Requested By: 2006-11-29 12:09:21.74 spid3 ResType:LockOwner Stype:'OR' Mode: S SPID:506 ECID:0 Ec:(0x6F7A7538) Value:0x42bd5bc0 Cost:(1/2710) 2006-11-29 12:09:21.74 spid3 2006-11-29 12:09:21.74 spid3 Node:2 2006-11-29 12:09:21.74 spid3 KEY: 1:30:1 (91013cde5e38) CleanCnt:1 Mode: U Flags: 0x0 2006-11-29 12:09:21.74 spid3 Grant List 0:: 2006-11-29 12:09:21.74 spid3 Owner:0x42bcd0e0 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:506 ECID:0 2006-11-29 12:09:21.74 spid3 SPID: 506 ECID: 0 Statement Type: SELECT Line #: 17 2006-11-29 12:09:21.74 spid3 Input Buf: Language Event: dbo.sp_MShasdbaccess 2006-11-29 12:09:21.74 spid3 Requested By: 2006-11-29 12:09:21.74 spid3 ResType:LockOwner Stype:'OR' Mode: X SPID:578 ECID:0 Ec:(0x491AD548) Value:0x42bcd320 Cost:(1/44) 2006-11-29 12:09:21.74 spid3 Victim Resource Owner: 2006-11-29 12:09:21.74 spid3 ResType:LockOwner Stype:'OR' Mode: X SPID:578 ECID:0 Ec:(0x491AD548) Value:0x42bcd320 Cost:(1/44) 2006-11-29 12:09:21.74 spid3 2006-11-29 12:09:21.74 spid3 End deadlock search 139 ... a deadlock was found.
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread