Saturday, 16 December 2017

How to Change Password in SQL Server 2012

How to Change Password in SQL Server 2012


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

No comments:

Post a Comment

React Hooks - custom Hook

  v CustomHook Ø React allows us to create our own hook which is known as custom hook. Example – 1 localStorage Demo Step-1 Create ...