This script kills all the processes using a given database. It is useful for removing users from a database so it can be restored.
To use this script change the server variable and the database variable at the top of the script. Notifications are written to the windows application eventlog.
Use this script at your own risk. It is always best to make sure you have an understanding of a script before implementing it.
This script is very helpful for anyone trying to recreate particular SQL Server Database Versions for Testing. It allows you to automatically recompile any stored procedures or views saved with drop, create and permission statements. The scripts must all be sitting in one directory and end in the same extension. I have found this very […]