Mega Code Archive

 

Categories / MSSQL Tutorial / User Role

 

Reporting Fixed Server Role Information

SELECT name FROM sys.server_principals WHERE type_desc = 'SERVER_ROLE' EXEC sp_helpsrvrole EXEC sp_helpsrvrolemember 'sysadmin'