Easily Kill All Users In A Database

This simple script (ran from the master database) in Query Analyser removes all the requirements of collating currently connected spids to a database and the need to systematically open a cursor to kill each spid individually by simply placing the database offline, then immediately online.

2 (1)

2007-03-16 (first published: )

359 reads

Blogs

Blogging – goal achieved – 72 days early

By

So I started blogging in 2016: So why blog….now? It is very interesting going...

Last Week Reading (2019-10-20)

By

Hello folks! 2 weeks passed but eventually, I have some news for you. Press...

Read the latest Blogs

Forums

Modular ETL Architecture Design in SSIS

By aveek22

Comments posted to this topic are about the item Modular ETL Architecture Design in...

Backing up SSAS Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backing up SSAS Databases

Losing The Security Game

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Losing The Security Game

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers