SQL Server Performance

SQL Server - Kill a KILLED/ROLLBACK status process without restarting Server or SQL services?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, May 6, 2008.

  1. Anonymous New Member

    This may be the typical situation within your database environment where the you might have killed a SPID (Process) that has been running for long time, without knowing the ROLLBACK operations for such processes. Say if you are executing a stored procedure which is built with a transactional based statements, by default the relational engine has the ability to control transactions mainly when you have specified a transaction starts and ends. In addition to that it must also be able to correctly handle...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2008/05/06/4120.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=4120" width="1" height="1">

Share This Page