Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Kill all Connections

By Justin-14543,

There are times you want to kill all the connections in a database. This would do that trick.

This can be very useful when you replace a database regularly and some connections still exist so your automated restore fails. You can issue this command to kill all the connections before issuing a restore command.

Total article views: 2413 | Views in the last 30 days: 3
 
Related Articles
FORUM

connections

connecting to sql

FORUM

remote connections

remote connections

FORUM

open connection

open connection

FORUM

COnnection failure

connection failure

FORUM

Remote Connections

Remote Connections

Tags
backup and restore    
t-sql    
 
Contribute