MS SQL: Steps to change login password

If you're wondering how to change your password for your Microsoft SQL account, you found the right place. I found Microsoft Support site which shows you how to change the login password for your account. To summarize it, this what you need to do;

1) Login to MSSQL using Command Prompt
(Go to Start -> Run -> type "cmd" and hit return)

2) Enter this command: osql -U username
(Replace username with your account name)

3) Key in your password to grant access into the account

4) Then follow with the command to change your password

sp_password @old = null, @new = 'complexpwd', @loginame ='sa'
go

(The null is meant for blank or empty(if you have password then type the password inside the colon('). The username "sa" is meant for system admin. Replace it with your account name.)

That's about it. Relogin and you are ready with your new password :)