Sunday, February 12, 2012

adding another system administrator

Hi all

I deleted the sa account

how do I add it with all the correct permissions (plus include it in all the tables )

TIA

Guy

Recreate the login 'sa', then add it to the sysadmin server roleSmile For more information about sa, take a look at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_8soe.asp

No comments:

Post a Comment