List out the server roles of an user – TSQL

SET NOCOUNT ON;

DECLARE @Login sysname;

SET @Login = ‘login_name’;

SELECT R.name AS ‘Server Roles’
FROM sys.server_role_members AS RM
JOIN sys.server_principals AS L
ON RM.member_principal_id = L.principal_id
JOIN sys.server_principals AS R
ON RM.role_principal_id = R.principal_id
WHERE L.name = @Login;