Technical Article

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: )

362 reads

Blogs

Daily Coping 30 Nov 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Fail activity in Azure Data Factory and Why would I want to Fail

By

(2021-Nov-30) I heard a story about a young person who was asked why she was...

Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

How to move Paas SQL Database from one subscription to another subscription

By jamessdba

Hi experts, Can some one please post procedure/Steps to move ( including Logins, Users)...

Arithmetic overflow error converting expression to data type datetime when selec

By JeremyU

I have such an issue. I want to select a column PDWEDT (it is...

inner join give me huge data when package id equal package id from another table

By ahmed_elbarbary.2010

I work on sql server 2014 i face issue when join two tables as...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers