Skip to content

Instantly share code, notes, and snippets.

@yuxhuang

yuxhuang/sqlserver_kill_connections.sql

Created May 31, 2013 15:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yuxhuang/5685761 to your computer and use it in GitHub Desktop.
Save yuxhuang/5685761 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqlserver_kill_connections.sql
-- set your current connection to use master otherwise you might get an error
use master
ALTER DATABASE YourDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
--do you stuff here
ALTER DATABASE YourDatabase SET MULTI_USER
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment