Kill All Sessions

1USE master;
2GO
3
4ALTER DATABASE [DatabaseName]
5SET SINGLE_USER
6WITH ROLLBACK IMMEDIATE;
7ALTER DATABASE [DatabaseName]
8SET MULTI_USER;
9GO