This script will attempt to kill all processes in a given database belonging to a given user. If the user is not specified it will attempt to terminate all users’ processes in the database. If the database name is not specified it will hunt the processes in all databases where such a user name exists.
Like other utilities, uspKillAllProcesses conveniently is located in a database called DBAservice. Tested in SQL Server 7, the script should also work with SQL Server 2000.
Author: Yul Wasserman
Disclaimer: We hope that the information on these script pages is
valuable to you. Your use of the information contained in these pages,
however, is at your sole risk. All information on these pages is provided
“as -is”, without any warranty, whether express or implied, of its accuracy,
completeness, or fitness for a particular purpose…
Back to Database Journal Home