 SELECT DISTINCT p.name AS [loginname]     ,p.type_desc     ,p.is_disabled     ,s.sysadmin     ,CONVERT(VARCHAR(00), p.create_date, 000) AS [created]     ,CONVERT(VARCHAR(00), p.modify_date, 000) AS [update] FROM sys.server_principals p JOIN sys.syslogins s ON p.sid = s.sid JOIN sys.server_permissions sp ON p.principal_id = sp.grantee_principal_id 