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 SPIDs with a certain user ID

By Ryan McCauley,

This script is used to disconnect all connections by a particular individual to a server. I use it when I have to disconnect somebody and they have too many processes to do it by hand. Normally, you can just connect the offending process, but if there are multiple processes that are causing a problem , you can use this script to just disconnect the user from the server.

If you run this procedure without any parameters, it will return a list of all active connections, along with the number of databases they're using and the number of connections they have. If you run it with a loginname as a parameter, it will kill all the instances of that login name.

WARNING - ANY UNCOMMITTED TRANSACTIONS WILL BE ROLLED BACK, SO USE CAREFULLY!

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

Mirroring disconnected.

mirroring disconnected

FORUM

Unexplained Client Disconnects

clients disconnect after a period of inactivity

ARTICLE

Quickly Disconnect Users

Nothing is more annoying than having to disconnect users one by one. With this script, you will be a...

FORUM

Connecting/Disconnecting using C++

Hello fellow SQLers. I am having a problem disconnecting properly using C++, I am creating an ADO r...

FORUM

user connection crash?

connection, process,sql server 2005

 
Contribute