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
 SQL Server Development (2000)
 Can't kill a process

Author  Topic 

rongrzywacz
Yak Posting Veteran

57 Posts

Posted - 2001-05-01 : 15:02:25
On our SS 7.0 sp3 box we ocassionally have a process, that appears to be rolling back a transaction that I can't kill, without shutting down sql server and restarting it.
This totally screws up our overnight processing. It looks like a sql server bug which was supposed to be fixed with the latest release, but aparently not. Is there anyway to manually shut down sqlserver and restart it from with a sql agent job when we hit this condition.
Thanks for any help



Ron Grzywacz
   

- Advertisement -