Microsoft SQL Server forum - sa Vs sysadmin login

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

sa Vs sysadmin login

liorhal@gmail.com

2005-05-30, 7:23 am

is there a difference in the previleges of 'sa' login and other login
with 'sysadmin' role (and 'db_owner' for all databases) ?
can they do the exact same things ?

Simon Hayes

2005-05-30, 7:23 am

sa is a member of the sysadmin role, so there's no difference.
Microsoft recommends that you don't use the sa account anyway - Books
Online says it's there for backwards compatibility only. See "System
Administrator (sa) Login" in BOL.

Simon

Sponsored Links