- KnowledgeBase >
- SQL >
- How to kill all active connections on MSSQL server
How to kill all active connections on MSSQL server
DECLARE @kill varchar(8000) = '';
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), spid) + ';'
FROM master..sysprocesses
WHERE dbid = db_id('MyDB')
EXEC(@kill);
Additional Articles
- Firewall
- Website Panels
- DELL
- Dynamic DNS
- Hardware
- P2V
- PineApp
- PRTG
- SSL
- VMware
-
Windows
- hmail
- IIS
- Logs
- Security
- How to change activation key in WIN2012
- How to configure time server in server 2003 & 2008
- How to disable the tcp connection limit per IP
- Scripts
- Basic Encoding
- Add disk cleanup utility in windows server 2008 r2
- Custom snmp for Windows
- Reduce Windows 7 +sp1 or 2008 +sp1 WinSXS Folder Size (Cleanup WinSXS After SP1 Install)
- How to install and set Remote Desktop Service
- How to recover DFS of a cloned windows server
- How to find files by size with PowerShell
- How to recover DFS of a cloned windows server (1)
- Wordpress
- DB
- Linux
- Public Cloud
-
SQL
- Backup SQL server Agent
- Backup resotre multiple bak files from directory
- Change db schema to dbo
- ChangeDBownerOnTables
- Export sqlusers with password and sid
- Found max big table
- Full Text Search On SQL
- How To Obtain The Size Of All Tables In A SQL Server Database
- Kill all active connections on DB
- SQL Server which database takes all memory
- How to change a mirrored database server to principal
- How to kill all active connections on MSSQL server
- What to do when SQL Server is in recovery
- How to Start SQL Server Instance in a Single User Mode
- SQL Change schema to dbo
- How to generate a memory usage by database report in mssql
- Switchs
- Backups
- More topics....
- Networking
X