database table will not drop (or show it's inputed data)

Question

hi, if i apply a sql query statement to this table "select * from context.tablename", all i see is the "Executing query.." message and nothing else hapens. I also can not truncate or drop this table. It prevents me from even dropping vhole database.

Is it possible, that this problem is caused by inserted data into this table???

I'm using MS Sql server 2005

Answer 1

Are there any open connections to the database while trying to drop the table? Have you tried closing all connections before dropping it?

Answer 2

Have you tried restarting the SQL Server service?

Answer 3

Use SSMS to detach the database. Delete the MDF files manually.