How to Change Password in SQL Server 2012

How to Change Password in SQL Server 2012

30JAN

To Change Password Programmatically

1. Open the SQL Server Management Studio.
2. Click new query to open a New Query.
3. Paste and execute the following code.

USE [master]

GO

ALTER LOGIN [sa] WITH PASSWORD=N’New Password’, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO