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.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-04-22 : 09:57:29
|
| I am trying to drop a table but when I do, it freezes and does not get dropped. Anyone know of a sure-fire way to drop a table?Messing with systables maybe? Or DBCC? Or mark as suspect?...Any ideas? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-22 : 10:05:45
|
quote:
Originally posted by coolerbob
Messing with systables maybe?
Good lord no.Did you do DBCC CHECKTABLE?Never heard of a drop "freezing" before.Can you TRUNCATE the table?Brett8-) |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-04-22 : 10:12:17
|
| Even "dbcc checktable ('sageexportsalestranstmp') with REPAIR_ALLOW_DATA_LOSS" hangs! I can't believe it either! We have an omni-table! cant kill it! help! help!truncate table hangs too!Help! It's coming to get me!Nothing is holding a reference to it. It's just a table on our development server. There are no records in it either |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-04-22 : 10:22:40
|
| The immortal table had it's fortune's reversed when I stopped and started the SQL Service and ran drop table again.Victory! All is well is SQL land. The DBA's have control again. Man 1:0 Machine |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-22 : 10:52:32
|
| My next suggestion would have been ALTER DATA and set it to single user mode with rollback immediate...Did you look at sp_who or sp_locks?Brett8-) |
|
|
|
|
|
|
DROP Table freezes