Home Forums SQL Server 2008 SQL Server 2008 Administration Can't Kill SPID “Transaction Rollback in Progress” RE: Can't Kill SPID “Transaction Rollback in Progress”

  • March 3, 2013 at 5:18 pm

    #1592837

    GilaMonster (3/3/2013)

    Welsh Corgi (3/3/2013)

    How do you check what the rollback session is waiting for?

    GilaMonster

    Same way you check what any session is waiting for, sys.dm_exec_requests

    If you believe that Kill with the statusOnly option is not working, file a bug report on Connect.[/quote

    I'm not going to ask you to open Google but do you have a favorite query to identify this?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/