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.. 

Like and Share to SQL Integrity Blog

No comments:

Post a Comment

Thank You !!!!