Search

Thursday, August 4, 2011

DISABLE and ENABLE user SA

SA can be disable or enabled using following script. Make sure that you are logged in using windows authentication account.
/* Disable SA Login */
ALTER LOGIN [sa] DISABLE
GO
/* Enable SA Login */
ALTER LOGIN [sa] ENABLE
GO



Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)