Just a day ago, I received question from blog reader Mike McDonald.
“How can I modify permissions for SA user? I tried to modify dbo users permission but now I am having problems.”
First of all, there may be no relation between dbo user and SA user. They are different and should be left separate.
Modifying the permission of SA user is not possible. However, SA can be disable or enabled using following script. Make sure that you are logged in using windows authentication account.
/* Disable SA Login */
ALTER LOGIN [sa] DISABLE
/* Enable SA Login */
ALTER LOGIN [sa] ENABLE
Reference : Pinal Dave (http://blog.SQLAuthority.com)