Kill all sessions in single database

USE master;
GO

ALTER DATABASE <DatabaseName>
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;

ALTER DATABASE <DatabaseName>
SET MULTI_USER;
GO

This site uses Akismet to reduce spam. Learn how your comment data is processed.