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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-16 : 08:02:05
|
| Jonathan writes "For days, I've been trying to drop a SQL Server 2000 DB. But SQL Server returns a message to the effect that it's in use so I'm not permitted to. OK, in Enterprise manager I expand the Management\Current Activity\Process Info nodes to see what's 'using' the DB.There I find 2 process IDs owned by sa in a sleeping state but connected to the db that I want to delete. I highlight each one, right-click and select Kill Process. Nada. They're still there! And I'm sa!Is there a way to Drop a database with brute force?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-16 : 08:03:02
|
| This might help:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40077 |
 |
|
|
|
|
|
Dropping a database with brute force