Steps to close active MSSQL connections on server

kumkumsharma

Administrator
Staff member
You can follow below steps to close active MSSQL connections.
  • Login to your server.
  • Go to SQL server management studio.
  • Here you will find new “query” option, where you have to add below query.
NOTE: You have to execute below script on MS SQL Server 2012 and higher versions.

Code:
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);
  • You can use below query for MS SQL Server 2000, 2005, 2008
Code:
USE master;
DECLARE @kill varchar(8000); SET @kill = '';
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), spid) + ';'
FROM master..sysprocesses
WHERE dbid = db_id('MyDB')
EXEC(@kill);
Above acript will close all the MSSQL active connections.
 
Top