Script to list DB User Roles for Logins

  SELECT 'EXEC sp_addrolemember N''' + USER_NAME(groupuid) + ''', N''' + USER_NAME(memberuid) + ''''+';'
FROM sysmembers where USER_NAME(memberuid) not in ('dbo', 'sa', 'public')