Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesis 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 ?
Post Follow-up to this messagesa 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
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread