The database table will not be reduced (or show its entered data)

Question

if I applied the sql query statement to this table "select * from context.tablename", all I see is the message "Query Execution .." and nothing else happens. I also cannot truncate or drop this table. This prevents me from even dumping the fence database.

Is it possible that this problem is caused by the inserted data in this table ???

I am using MS Sql 2005 server

Answer 1

Have you tried restarting the SQL Server service?

Answer 2

- ? , ?

Answer 3

SSMS . MDF .

Answer 4

, 3 . MS SQL Server Mgmt Studio , , .

, . sp_spaceused , 86k , .

I disabled all tabs, including the one I used, to select and to delete the table. Then I reconnected to this window and ran "Select * from" my table, and it worked. I was also able to successfully delete the table.

It seems that there was an open connection holding the table hostage somehow and preventing Select and Drop from working.