script to check the role for users in sqlserver:

SELECT 'EXEC sp_AddRoleMember ''' + DBRole.NAME + ''', ''' + DBUser.NAME + '''' AS '--Add Users to Database Roles--'

FROM sys.database_principals DBUser

INNER JOIN sys.database_role_members DBM ON DBM.member_principal_id = DBUser.principal_id

INNER JOIN sys.database_principals DBRole ON DBRole.principal_id = DBM.role_principal_id