SELECT user_name([memberuid]) AS [Username], User_Name([groupuid]) AS [Role_Name]
FROM [sys].[sysmembers]
WHERE User_Name([groupuid]) = 'szop_general'

SELECT l.loginname AS [Login_Name],u.name AS [Username] FROM sysusers u
INNER JOIN master..syslogins l
ON u.sid=l.sid