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:Click to share on Facebook (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Reddit (Opens in new window)Click to print (Opens in new window)Click to share on Twitter (Opens in new window)Click to email this to a friend (Opens in new window)Click to share on Pinterest (Opens in new window)Like this: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.