Old Password is required if a user was changing the password. If you were changing the password with SysAdmin account it doesn't care. It allows for force over-write. Just in case user lock out their account and you need to reset the password :).
I tried in SQL Server 2005, SP2.
When I set the password using SA, no issues. I logged on to the user and did password set, and I get this message:
Msg 15151, Level 16, State 1, Line 1
Cannot alter the login 'test', because it does not exist or you do not have permission.
:).
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]