• Restart SQL.

    There isn't a process at the OS level to kill (and if you have the idea of killing threads within SQL from the OS, that'll likely crash the SQL service at best)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass