Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to retrieve inaccessible table?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Recouvrement
Titre:
How to retrieve inaccessible table?
Divers
Thread ID:
00470923
Message ID:
00470923
Vues:
66
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform