Return to Question

I created some columns in our production database but now I need to drop one. However this seems impossible and I do not know why. I dropped the column in our development database just fine. I created a table in production and dropped that. But when I try to remove this one column I get the error. I used management studio (which fails quickly) and T-SQL (which takes longer but still fails).

ALTER TABLE VEN DROP COLUMN RI_VEN_Approved 

[![lock request time out period exceeded][1]][1]

Any idea whats going on?

I checked for locks using a query found here https://stackoverflow.com/questions/1511675/how-to-check-if-a-table-is-locked-in-sql-server

Using this query specifically:

SELECT resource_type, resource_associated_entity_id, request_status, request_mode,request_session_id, resource_description, o.object_id, o.name, o.type_desc FROM sys.dm_tran_locks l, sys.objects o WHERE l.resource_associated_entity_id = o.object_id and resource_database_id = DB_ID() 

The table did not appear in the results.

I ran sp_who2 and did not see anything in the BlkBy column. [1]: https://i.sstatic.net/222Pn.png

I created some columns in our production database but now I need to drop one. However this seems impossible and I do not know why. I dropped the column in our development database just fine. I created a table in production and dropped that. But when I try to remove this one column I get the error. I used management studio (which fails quickly) and T-SQL (which takes longer but still fails).

ALTER TABLE VEN DROP COLUMN RI_VEN_Approved 

Any idea whats going on?

I checked for locks using a query found here: https://stackoverflow.com/questions/1511675/how-to-check-if-a-table-is-locked-in-sql-server

Using this query specifically:

SELECT resource_type, resource_associated_entity_id, request_status, request_mode,request_session_id, resource_description, o.object_id, o.name, o.type_desc FROM sys.dm_tran_locks l, sys.objects o WHERE l.resource_associated_entity_id = o.object_id and resource_database_id = DB_ID() 

The table did not appear in the results.

I ran sp_who2 and did not see anything in the BlkBy column.

I created some columns in our production database but now I need to drop one. However this seems impossible and I do not know why. I dropped the column in our development database just fine. I created a table in production and dropped that. But when I try to remove this one column I get the error. I used management studio (which fails quickly) and T-SQL (which takes longer but still fails).

ALTER TABLE VEN DROP COLUMN RI_VEN_Approved 

Any idea whats going on?

I created some columns in our production database but now I need to drop one. However this seems impossible and I do not know why. I dropped the column in our development database just fine. I created a table in production and dropped that. But when I try to remove this one column I get the error. I used management studio (which fails quickly) and T-SQL (which takes longer but still fails).

ALTER TABLE VEN DROP COLUMN RI_VEN_Approved 

[![lock request time out period exceeded][1]][1]

Any idea whats going on?

I checked for locks using a query found here https://stackoverflow.com/questions/1511675/how-to-check-if-a-table-is-locked-in-sql-server

Using this query specifically:

SELECT resource_type, resource_associated_entity_id, request_status, request_mode,request_session_id, resource_description, o.object_id, o.name, o.type_desc FROM sys.dm_tran_locks l, sys.objects o WHERE l.resource_associated_entity_id = o.object_id and resource_database_id = DB_ID() 

The table did not appear in the results.

I ran sp_who2 and did not see anything in the BlkBy column. [1]: https://i.sstatic.net/222Pn.png

I'm using SQL Server 2005. To post a question requires a tag however this site fails to provide the appropriate tag, SQL Server or SQL Server 2005.

I created some columns in our production database but now I need to drop one. However this seems impossible and I do not know why. I dropped the column in our development database just fine. I created a table in production and dropped that. But when I try to remove this one column I get the error. I used management studio (which fails quickly) and T-SQL (which takes longer but still fails).

ALTER TABLE VEN DROP COLUMN RI_VEN_Approved 

Any idea whats going on?

I created some columns in our production database but now I need to drop one. However this seems impossible and I do not know why. I dropped the column in our development database just fine. I created a table in production and dropped that. But when I try to remove this one column I get the error. I used management studio (which fails quickly) and T-SQL (which takes longer but still fails).

ALTER TABLE VEN DROP COLUMN RI_VEN_Approved 

Any idea whats going on?