How to enable or disable ‘sa’ login? 2 Replies /* To disable 'sa' Login */ ALTER LOGIN [sa] DISABLE GO /* To Enable 'sa' Login */ ALTER LOGIN [sa] ENABLE GO Share this: Share on Facebook (Opens in new window) Facebook Share on Tumblr (Opens in new window) Tumblr Share on LinkedIn (Opens in new window) LinkedIn Share on Reddit (Opens in new window) Reddit Print (Opens in new window) Print Share on X (Opens in new window) X Email a link to a friend (Opens in new window) Email Share on Pinterest (Opens in new window) Pinterest Like Loading... Related
Santhosh April 14, 2011 at 7:43 am 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’. Reply ↓
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.