Posted by : Jebastin
Monday, 8 September 2014
In this article we will take a look at how to change SA Password in SQL Server
using TSQL code and by using SQL Server Management Studio. The steps mentioned
in this article are applicable to change any SQL Server Login Password works on
SQL Server 2005 and higher versions.
T-SQL Statement:
Use Master
Go
ALTER LOGIN [sa] WITH PASSWORD=N'JJSqlServer', CHECK_POLICY = OFF
Go
T-SQL Statement:
Use Master
Go
ALTER LOGIN [sa] WITH PASSWORD=N'JJSqlServer', CHECK_POLICY = OFF
Go