Running SQL Server 7.0(service pack 1), on NT40(service pack 5).
I have recently discovered that one table in my common DB is not accessible. It shows up in Enterprise Manager, and I can view the design properties. However, I cannot perform *any* query on the table. No selects, no updates, not even a drop. I cannot delete the table from within Enterprise Manager either (I'm assuming all it does is a drop command, which I can't do from the query analyzer.)
I have run dbcc checkdb on the common DB, as well as dbcc checktable on the table in question. Anytime I try these, or any query on the table, the application (Enterprise Manager/Query Analyzer, or my app that references the table in question) freezes. This is really odd since all other tables in the common DB are fine and in working order.
I have checked the error logs - no errors have been recorded.
Anyone have suggestions as to how this happened, or more importantly, how to fix it? I really don't want to restore the entire database....
Thanks in advance!
- Kile