Kill user connections

Kill user connections.

Last updated: 19 September 2016

Warning: Review and test in a non-production environment before running.

Back to results

USE master;
GO

ALTER DATABASE [database_name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO

ALTER DATABASE [database_name] SET MULTI_USER;
GO