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?
Chris McCandless
Red Sky Software