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.
sp_who2 and did not see anything in the