Who Is Really a Sysadmin? Expanding AD Groups in SQL Server with xp_logininfo
When you audit who has sysadmin rights on a SQL Server instance, the answer is often an Active Directory group rather than a list of people. A login such as DOMAIN\SQL DBA tells you a group has full control, but not who is actually in it. Many DBAs do not have access to Active Directory…