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.

Cheers,
Eric


>Uh oh. I ran a program on my database over the weekend to delete a ton of records. Around 21 million or so. When I come in this morning, it seems as if SQL Server 7.0 is trashed. I can use Query Analyzer on the other databases on the server, but when I try to switch to my database, it hangs. Also, Enterprise Manager hangs when I try to expand the Databases tab. I am not really sure where to begin on this. I am guessing DBCC, but I have not used that before. Any ideas?