Skip to content

Instantly share code, notes, and snippets.

@JosiahSiegel
Created March 23, 2015 16:52
Show Gist options
  • Save JosiahSiegel/6b87a4181327391cfec0 to your computer and use it in GitHub Desktop.
Save JosiahSiegel/6b87a4181327391cfec0 to your computer and use it in GitHub Desktop.
#MSSQL Kill SPID, generate report
--run both commands
KILL 54;
--generates progress report
KILL 54 WITH STATUSONLY;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment