SET NOCOUNT ON;
DECLARE @Login sysname;
SET @Login = ‘login_name’;
SELECT CASE P.state WHEN ‘W’ THEN
P.permission_name + ‘ WITH GRANT OPTION;’
ELSE
P.state_desc + ‘ ‘ + P.permission_name
END AS ‘Server Permission’
FROM sys.server_permissions AS P
JOIN sys.server_principals AS L
ON P.grantee_principal_id = L.principal_id
WHERE L.name = @Login
AND P.class in (‘100′,’101′,’105’)