I attempted a multiple update that caused an endless process because I had
failed to deal with multiple updates in my trigger. I tried to cancel the
process first through Enterprise Manager and then through ISQL but could
not get it to cancel. If I had waited long enough my logs would have
filled up and the process would have aborted, but instead I stopped SQL
Service on my workstation (I am at a test bench). When I returned to
Enterprise Manager my database had a 'Restoring' beside it. It never
restored itself, however, and so I dropped it and created a new database
with a backup I had.
How do you kill a process that does not want to die?
Thanks for any information.