sqlnaive (8/1/2011)
We give our scripts to system DBAs to run. So we don't want them to know what our password is, thats why must_change option. Once we changed the password, can we put the check_expiration off again ?
Hi again
Okay, then you need to have the DBAs create the login like this:
CREATE LOGIN [yourlogin] WITH PASSWORD=N'somepassword' MUST_CHANGE, DEFAULT_DATABASE=[yourdb], CHECK_EXPIRATION=ON
Then proceed to login and change the password.
Finally have the DBAs run this:
ALTER LOGIN [yourlogin] WITH CHECK_EXPIRATION=OFF
Kind regards
Lars Søe Mikkelsen