SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Updating Changed Passwords for warm Servers

By kenkaufman,

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 passwords.  Although Im certain there must be script or tool that does this I was unable to locate it.  As a fix I wrote the following script for updating passwords between to SQL 7 DBs. 

Total article views: 121 | Views in the last 30 days: 1
Related Articles

Password change

Password change


change password

change password


PowerShell – Change SQL Server Login Password

Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL ...


changing the connection password hrough another package

changing the connection password through another package


Changing Replication Passwords

A how-to guide for configuring replication agents after a password change