Cannot Drop or Alter Table - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Cannot Drop or Alter Table

Author

Topic

hismightiness
Posting Yak Master

164 Posts

Posted - 2005-07-06 : 17:12:51

I have a table that I cannot drop or alter at all. I have tried through EM and Query Analyzer. Either way, the script either never completes its execution, or it times out. In the case of EM, it locks up the program entirely.

Here is the table:

CREATE TABLE MyTable ([qid] uniqueidentifier NOT NULL, 
[queue_id] int NOT NULL, 
[message_id] int NOT NULL)

I really want the table to be dropped, but it won't let me. I have tried the following methods without any favorable results:

DROP TABLE MyTable

ALTER TABLE MyTable DROP COLUMN quid

Can someone assist me in getting rid of this troublesome table, please?

- - - -
- Will -
- - - -
http://www.servicerank.com/

nathans
Aged Yak Warrior

938 Posts

Posted - 2005-07-06 : 17:53:47

Sounds like someone may have opened a transaction on said table.

Nathan Skerl

hismightiness
Posting Yak Master

164 Posts

Posted - 2005-07-06 : 17:57:53

Argh! Something so simple and I overlooked it. As soon as I disconnected all of the connections to this DB, I was able to drop the table. Thank you for your reply. You were a great help!

- - - -
- Will -
- - - -
http://www.servicerank.com/

nathans
Aged Yak Warrior

938 Posts

Posted - 2005-07-06 : 18:03:36

Glad to help yo.

Nathan Skerl

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources