SQL 2008: clearing current connections

Published by

Posted on March 27, 2011

You can clear the current SQL connections by issuing the following query

USE master;
GO
ALTER DATABASE dbName
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE dbName
SET MULTI_USER;
GO

Categories: SQL