/* To disable 'sa' Login */
ALTER LOGIN [sa] DISABLE
GO
/* To Enable 'sa' Login */
ALTER LOGIN [sa] ENABLE
GO
How to enable or disable ‘sa’ login?
Comments
2 responses to “How to enable or disable ‘sa’ login?”
-
Where this command is run ? I tried on SQL Query Analyzer, it give error
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ‘LOGIN’.-
It will work with 2005 version onwards only.
-
Thanks for the comment, will get back to you soon… Jugal Shah