Microsoft – SQLServer – Transaction Rollback – Status

Microsoft – SQLServer – Transaction Rollback – Status

Needed help monitoring the status of a transaction rollback.

If the process is already killed, then you might try using “kill <x> with status only”.

replace <x> with the SPID/session_id.


       kill  with status_only;


       --if the session we will like to kill is session_id 53
       kill 53 with status_only;

Here are a couple of online gems.

1) Kill (Transact-SQL)

2) Monitor Transaction Rollback

3) How long will this rollback take?

4) Killed /Rollback 

5) SQLMail hung in Schedule Job – Restart it without restarting SQL Server


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s