Question: How to Kill User Sessions (SPID) in SQL Server? Answer: Before I answer this question, I need to ask one more question – “Why do you want to kill all of the user sessions in your SQL Server?” Honestly, I do not see any valid business logic to kill all the SPID in the SQL…

via How to Kill User Sessions (SPID) in SQL Server? – Interview Question of the Week #140 — SQL Authority with Pinal Dave