Cannot able to drop the table

[former_member203645]

     Hi All,

I cannot able to drop a table, I don't know why ?? Please advise me.

Here is the error below.

The Object cannot be opened for DROP or ALTER. It is already open.
SQL Code = -1000018, ODBC 3 State = "HY000"
Line 1, Column1

[saroj_bagai · Accepted solution]

check with sp_iqconnection /sp_iqcontext/sp_iqtransaction. other user  is using this table, commit that user's transaction. Alter and drop need exclusive write lock, You cann't alter/drop table if other user is using that table.    

[markmumy · Accepted solution]

You could also look at sp_iqlocks to see which connection has a lock on that table.

[Former Member · Accepted solution]

Just curious, how do you commit other's user transacttion?

[markmumy · Accepted solution]

You cannot. The user/app needs to do that.  A DBA or other user cannot commit transactions on other connections.

[Former Member · Accepted solution]

Thanks

[Former Member]

Hi RUC,

Were you able to drop the table here ?

Let us know if you are still hitting the issue, and/or if you could identify which other user was using the table.

Thanks

Andrew