Changing the sa password using sqlcmd

Since Visual Studio does not allow us to reach security options of the local SQL instance, even with the new VS 2010. One might have to leverage sqlcmd to change the sa password, or any password, for that matter.

Just fire up a command prompt, punch in

–> sqlcmd
–> sp_password @new = “newpassword”, @loginame = “sa”
–> go
–> exit

That’s all