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 |
|
Shastryv
Posting Yak Master
145 Posts |
 Posted - 2004-10-04 : 11:13:38
|
| Is there any way I can get rid of the Killed/Rollback processes from the sysprocesses with out restarting the sql server service??? These transaction are struck from 3 to 4 days has nothing but an active connection to sql server and no active connection on OS side however it showing the KPID a non zero value. Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-04 : 13:42:53
|
| No. You either have to wait for it to finish rolling back or restart the service.Tara |
 |
|
|
|
|
|
Killed/Rollback