Change password of sa login.

//change password of sa login

//Login to SQL Server with sa login

//The syntax is

sp_password 'old password','new password'

'new password' should not be null or sa.

//close Management Studio and again Login with sa. you have to

//enter new password.

//This syntax can be useful if we Login using Windows authentication
sp_password 'old password','new password','sa'

---------------------------------------------------------------------------
//change password without using the old password.
alter login sa with password='new password'

ALTER LOGIN <LoignName> WITH 

PASSWORD = '<New Password>' 

OLD_PASSWORD = '<Old Password>'

GO