Breaking News: Grepper is joining You.com. Read the official announcement!

close all connections to database sql server

YOU.com answered on November 4, 2021 Popularity 8/10 Helpfulness 4/10

answer close all connections to database sql server

related sql server kill all connections

close all connections to database sql server

Comment

DECLARE @sql NVARCHAR(MAX) = N'';

-- Generate KILL statements for each active connection
SELECT @sql += N'KILL ' + CAST(spid AS NVARCHAR) + N';'
FROM sys.sysprocesses
WHERE dbid = DB_ID('YourDatabaseName') -- Replace 'YourDatabaseName' with the name of your database
AND spid > 50; -- Exclude system processes

-- Execute the generated KILL statements
EXEC sp_executesql @sql;

Popularity 8/10 Helpfulness 4/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

Closely Related Answers

sql server kill all connections

Comment

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);

Popularity 9/10 Helpfulness 10/10 Language sql

Source: stackoverflow.com

Tags: kill

Link to this answer
Share Copy Link