I am unable to stop MSSQLSERVER!!! Please Help!
I was attempting to drop a constraint from a table and got a lock request time out exceeded. I made sure no one was logged into the DB (exept me) and then killed (using kill spid) all of the open connections. I attempted to drop the constraint again with the same result. I thought since no one is connected to the DB I will stop and start SQL using the service manager but MSSQLSERVER changes to "Stopping..." but has yet to stop (1 hr 20 min later).
I am lost on what action to take next. Any help is much appreciated!