That is interseting .. I didn't expect that answer.
I expected if SQL Server was told not to force password expirey then following will not be checked:
Enforce password history
Minimum password age
Simplying the following:
Minimum password length
Password must meet complexity requirements
But as I said I assumed, so even though the password does not expire. User can still change their password multiple times. So in your experiment you tried to change password, and it didn't let you change password too soon? And it kept the history for previous password? Thanks for the good question :). I'll have to remeber that.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]