title: sync SQL Server 2005 login passwords
body: <p>Background:<br/>
  We are running a web application where each user has a login to the system.  The application login is mapped to an actual SQL Server 2005 login (which we needed to create).  Our development and disaster recovery sites are simply copies of this setup.  On a nightly basis, the production database is backed up, the dump is archived, and we restore dev and DR using this file.  When this is done, we need to run sp_change_users_login for each user to remap the database user to the SQL login.</p>
  
  <p>Problem:<br/>
  When the user changes their password on production, the SQL login password is changed.  This is not getting synced to dev/DR, so if they try to log on to one of those sites, they can't, and need to reset their password.  Is there a [good] way to keep these SQL logins synced across multiple installs?</p>
  
  <p>The next version of this product eliminates the SQL login need, but upgrading is not a current priority.</p>