How do I script a password change for a SQL server login?

Question

Just what the title says, I need to change the password for an existing sql server login and I want to do it via sql script.

Answer 1

ALTER LOGIN

http://msdn.microsoft.com/en-us/library/ms189828.aspx

Answer 2

http://support.microsoft.com/kb/936492