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 - 2004-09-22 : 08:57:11
|
| Tricia writes "I have a 3rd party application that uses a SQL 2k database. The application is not working and I want to take the database offline but I can't get rid of the current process id's. I tried killing them but that only caused a 'rollback'. Now all the process id's are showing Command of "Killing/Rollback". How can I get rid of these?" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-22 : 23:10:24
|
| Let the rollback finish.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
SQL Server 2000 - Kill Process