Sometimes I need to know who has system administrator privileges in Microsoft SQL Server. Here’s a SQL snippet to list the sysadmins.
Listing Sysadmins in MSSQL
SELECT [name] FROM sys.syslogins WHERE sysadmin=1 AND (isntuser=1 OR isntgroup=1);
You should see something similar to this in response (depending on your version of Windows, SQL Server, and any changes you have made):
[name] NT AUTHORITY\SYSTEM NT SERVICE\MSSQL$SQLEXPRESS NT AUTHORITY\NETWORK SERVICE