Pages

Saturday, September 21, 2013

SQL SERVER – Enable Login – Disable Login using ALTER LOGIC – Change name of the ‘SA’ | Journey to SQL Authority with Pinal Dave

In SQL SERVER 2005, all the login (including 'sa' ) can be enabled and disabled using ALTER LOGIN command. To disable 'sa' login: ALTER LOGIN sa DISABLE GO To enable 'sa' login: ALTER LOGIN sa ENABLE GO Also for additional security (prevent educated guess from hackers) the name of the 'sa' account can be changed.… Continue Reading...

Source: SQL SERVER – Enable Login – Disable Login using ALTER LOGIC – Change name of the ‘SA’ | Journey to SQL Authority with Pinal Dave