Advanced Search

Return to Snippet

Revision: 44084
at April 6, 2011 01:02 by tclancy
Initial Code 
ALTER DATABASE DB_NAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
GO 
-- do stuff
Go 
ALTER DATABASE DB_NAME_NEW  SET MULTI_USER -- set back to multi user 
GO
Initial URL 
http://stackoverflow.com/questions/11620/how-do-you-kill-all-current-connections-to-a-sql-server-2005-database
Initial Description 









Initial Title





Kill Connections to SQL Server









Initial Tags














Initial Language





SQL