Wednesday, October 5, 2011

How to change your own password in SQL Server using ALTER LOGIN

This isn't documented very well.  If you are using ALTER LOGIN to change your own password, you need to supply your existing password as OLD_PASSWORD:

Alter Login [my_login] WITH PASSWORD = 'newpassword' OLD_PASSWORD = 'oldpassword'

0 comments: