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

close connections ms sql server

Claudio Vizzini answered on March 15, 2023 Popularity 1/10 Helpfulness 1/10

answer close connections ms sql server

related close all connections to database sql server

close connections ms sql server

Comment

DECLARE @dbname NVARCHAR(128)
SET @dbname = 'DB name here'
 -- db to drop connections 
DECLARE @processid INT 
SELECT  @processid = MIN(spid)
FROM    master.dbo.sysprocesses
WHERE   dbid = DB_ID(@dbname) 
WHILE @processid IS NOT NULL 
    BEGIN 
        EXEC ('KILL ' + @processid) 
        SELECT  @processid = MIN(spid)
        FROM    master.dbo.sysprocesses
        WHERE   dbid = DB_ID(@dbname) 
    END

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: sql sql-server

Link to this answer
Share Copy Link

Contributed on Mar 15 2023

Claudio Vizzini

0 Answers Avg Quality 2/10

Closely Related Answers

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 7/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

close connections ms sql server

Contents

More Related Answers

close connections ms sql server

Closely Related Answers

close all connections to database sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.