User Role MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. User Role
  4. Reporting Fixed Server Role Information
SELECT name
FROM sys.server_principals
WHERE type_desc = 'SERVER_ROLE'
EXEC sp_helpsrvrole
EXEC sp_helpsrvrolemember 'sysadmin'