I use the sa account on a 'Development' SQL Server. I'm trying to make sure the Network Admins have full access to this SQL Server when I'm on vacation etc, in case there's an issue.
On the Login Properties on the Sql Server Management Studio, if I check 'sysadmin' will that mean the other Roles are irrelevant. Also, if I check 'sysadmin' does that make the User Mapping (i.e. Database access) section is irrelevant?
Does someone with Full Windows Admin Access, automatically receive full SQL Server admin access through Windows Authentication?
Thanks