Post reply

kill 63 won't die.

  • October 9, 2007 at 6:52 am

    #73768

    kill 63 with statusonly

    SPID 63: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0 seconds.

    select req_spid,req_transactionUOW from master..syslockinfo where req_spid = 63

    no records found.

    exec sp_lock

    no records found for sp_id = 63

    Status has been on runnable for a day alrady..any ideas?

  • October 9, 2007 at 7:55 am

    #740365

    reboot.

    Something's wrong. I've seen this at times and the only thing that will clear it is a restart of SQL Server. The rollback will likely completely quickly when it restarts.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply