Try

sp_change_users_login 'Auto_Fix', 'UserName'



Todd Shain
Senior Database Administrator


A-Life Medical, Inc.


-----Original Message-----
From: Ligda John
[mailto:mssqldba-ezmlmshield-x83740180.[Email address protected]
Sent: Wednesday, May 30, 2007 11:09 AM
To: LazyDBA Discussion
Subject: restoring encrypted passwords

I have a nuisance when going through my DR routine; synchronizing
passwords for users whose passwords have changed.



Although there is a way to add a login when you have its encrypted
password, and there is a way to see whether the source and destination
passwords are the same, there doesn't seem to be a way to update a
password for a login if you only have the encrypted password. So you
have to drop and re-add the login. This is SQL 2000



John



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page