Technical Article

usp_KillUsers2

This script expands on the usp_KillUsers script posted by Brian Knight, by adding the text of the process that is being killed and will even kill users who are accessing the database from with in a process of another database. Does not contain the NET SEND option though.

2005-04-22 (first published: )

289 reads

Blogs

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Read the latest Blogs

Forums

Review Early and Often

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Review Early and Often

SQL Agent jobs - script to get what jobs failed

By Summer90

I have been trying to find SQL that shows what SQL Agent jobs failed...

Need help desperately

By Chitown

I accidentally ran this on a dev server which has locked my acct and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers