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 vote201 views1 answer
Login failed for user sql server
SQL
0 vote189 views1 answer
Sql string contains case sensitive
SQL
0 vote192 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote157 views1 answer
Running query in redshift
SQL
0 vote3.6K views1 answer
PSQL use LIKE with timestamps
SQL
0 vote169 views1 answer
Postgres read table structure
SQL
0 vote171 views1 answer
Convert rows to columns in sql server
SQL
0 vote201 views1 answer
Postgres - Login and connect as default user
SQL
0 vote183 views1 answer
Data directory postgresql
SQL
2 votes178 views2 answers
Mysql limit
SQL