Sql server kill all connections

USE [master];

DECLARE @kill varchar(8000) = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM sys.dm_exec_sessions
WHERE database_id  = db_id('MyDB')

EXEC(@kill);

Source: stackoverflow.com

Similar codes

0 vote232 views1 answer
Frename oracle
SQL
0 vote241 views1 answer
Order child below the parent in mysqli
SQL
-2 votes257 views1 answer
How-to-remove-mysql-root-password
SQL
1 vote262 views1 answer
Mysql previous year
SQL
2 votes240 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
11 votes248 views5 answers
Sql server reset identity
SQL
2 votes239 views4 answers
Mysql get all tables row count
SQL
0 vote215 views1 answer
How many columns can be used for creating index?
SQL
3 votes244 views1 answer
Sql print all names that start with a given letter
SQL
0 vote232 views1 answer
Why we have to set the password for my sql server
SQL