Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Enterprise Manager Not Responding
Message
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Miscellaneous
Thread ID:
00751426
Message ID:
00751508
Views:
28
Hi Eric,

Thanks for responding as I am in a bit of a jam here. It appears that one SPID is blocking another, but unfortunately I don't know enough about SPID to diagnose the problem. I have EM online intermittently, and the SPID that appears to be blocking another is 7, but it won't let me KILL it. It also does not show up when I run sp_who. Not wure what that means. I am running DBCC OPENTRAN, but it is still running.

Unfortunately, I was not able to run TRUNCATE TABLE as I was only deleting some of the records. Thanks again for your help. I am pulling my hair out :-).

>You can use DBCC CHECKDB, but I'm not sure it will give you the info your looking for. Try running DBCC OPENTRAN to see if there are any open transactions. If so, I would probably try to kill the culprit connection, if that didnt work, I would bite the bullet, restart the server and do a restore.
>
>Just another tip, if you are deleting all the records in a table you can use TRUNCATE TABLE, this will toast all the records without logging the deletions.
Chris McCandless
Red Sky Software
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform