Change password in SQL Server

In next couple of posts i will explain about some very usefull stored procedures in SQL Server.

SP_PASSWORD: SP_PASSWORD OLD_PASS,NEW_PASS [, LOGIN_ID]

Your password is shared and wants to change the password then you need to use sp_password stored procedure. The sp_password stored procedure is used to modify the password of a login ID. You need to pass the old password of a login ID as a parameter to create a new password. You need to specify the old password as NULL when you modify the password of the SA login ID.

Microsoft is planning to remove this stored procedure usage in future versions and suggesting us to use “ALTER LOGIN” command.