This script to designed to kill all connections for all users to a specified database. This is used in conjunction with an automated QA/Dev database restore/refresh process run as a DTS job.
One of the challenges weve faced is changing passwords in a warm server to reflect changes made to the live server. The initial transfer of users and passwords was performed by the sp_help_revlogin script provided by Microsoft at http://support.microsoft.com/default.aspx?scid=kb;en-us;246133. The difficulty with this script was once the users are in place, you cant sync changed […]