Monday, March 19, 2012

drop or rename a table problem

I tried to drop or rename a table and it hang up for 5 minutes in Enterprise
Manager. Then I hard close EM and open it again. The table has not dropped
or changed. May I know how else can I drop the table? Thanks.Use Query Analyzer to drop the table.
drop table <table name>
Regards
Amish Shah|||Is it in 2000 or 2005?
As you didnt recive do not have persmission error iam ruling it out.
Whats the size of the table, if its huge better dont go for Em method, it
can put the EM in hung state. Use
"DROP TABLE tablename" in query analyzer.
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"00KobeBrian" wrote:
> I tried to drop or rename a table and it hang up for 5 minutes in Enterprise
> Manager. Then I hard close EM and open it again. The table has not dropped
> or changed. May I know how else can I drop the table? Thanks.
>
>

No comments:

Post a Comment