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) Facebook Click to share on Tumblr (Opens in new window) Tumblr Click to share on LinkedIn (Opens in new window) LinkedIn Click to share on Reddit (Opens in new window) Reddit Click to print (Opens in new window) Print Click to share on X (Opens in new window) X Click to email a link to a friend (Opens in new window) Email Click to 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.