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

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

https://dragonsdenketo.com/peau-jeune-creme/

By aronscoates

Peau Jeune Creme The ingredients labels on anti aging skin care products are your...

What is the reason behind Driver unavailable error in window?

By Jeromeassistant

Casting insight on different aspect of the assembling and configuration part of printer.  The...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers