Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to retrieve inaccessible table?
Message
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Title:
How to retrieve inaccessible table?
Miscellaneous
Thread ID:
00470923
Message ID:
00470923
Views:
67
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
Next
Reply
Map
View

Click here to load this message in the networking platform