Microsoft SQL Server

Monday, July 9, 2012

SQL SERVER - How to enable or Disable to default User Account SA

It is very easy to enable or disable to SA Login Account In SQL Server. but we cannot change the permission of SA Login Account.
The Following Script can use for do the things- 

-- Script for Disable SA Login Account
ALTER LOGIN [sa] DISABLE
GO
-- Script for Enable SA Login Account
ALTER LOGIN [sa] ENABLE
GO

If there is any other method to do thing so please comment here.. 

No comments:

Post a Comment

Thank You !!!!