Skip to content

Instantly share code, notes, and snippets.

@benmccallum

benmccallum/MSSQL Server - Kill all processes on a DB.sql

Last active August 29, 2015 14:24
Show Gist options
  • Save benmccallum/7c9a4b61097ec759aa5d to your computer and use it in GitHub Desktop.
Save benmccallum/7c9a4b61097ec759aa5d to your computer and use it in GitHub Desktop.
Download ZIP
MSSQL Server - Kill all processes on a DB
Raw
MSSQL Server - Kill all processes on a DB.sql
USE master;
GO
ALTER DATABASE AdventureWorks
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
ALTER DATABASE AdventureWorks
SET MULTI_USER;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment