Corrupted Table removal problem

I have a table that I can no longer make design changes too, remove
altogether, or view all rows for. Enterprise manager just hangs. I can do
a view top 1 record, but not view all. I'm testing some stored procedures
to fill ntext fields using writetext and seem to be corrupting it somehow.
All other tables and database work fine ... problems occur here only.
Ideas on how to fix or move forward with this.
Thanks,
Andrew
Your best bet is usually to restore from a previous good backup. If this is
a table in which the data is not critical or can be rebuilt you might want
to take a look at DBCC CHECKTABLE in BooksOnLine.
Andrew J. Kelly SQL MVP
"Andrew Jones" <ajones@.kvmhc.org> wrote in message
news:10fdjev1ikfg8ac@.corp.supernews.com...
> I have a table that I can no longer make design changes too, remove
> altogether, or view all rows for. Enterprise manager just hangs. I can
do
> a view top 1 record, but not view all. I'm testing some stored procedures
> to fill ntext fields using writetext and seem to be corrupting it somehow.
> All other tables and database work fine ... problems occur here only.
> Ideas on how to fix or move forward with this.
> Thanks,
> Andrew
>