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: 2005-04-04)
289 reads
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
Comments posted to this topic are about the item Review Early and Often
I have been trying to find SQL that shows what SQL Agent jobs failed...
I accidentally ran this on a dev server which has locked my acct and...
Ask SSC