I tried killing this SQL session, but it never disappears. When I use "KILL ## WITH STATUSONLY", I get:
SPID ##: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.
I know what is executing it which was my web tool that edits the sql server. I tried restarting the App Pool but this did not do anything. I eventually IISRESTART and the session disappears.
No comments:
Post a Comment