Ohh thats a great idea. However I tried something like this and it worked as well but i like ur solution much better. Thanks again.

SELECT @ScriptPer = 'select ''USE [' + @DB_Name +'] ''''EXEC sp_addrolemember N'''''' + role_name + '''''', N'''''' + login_name + '''''''' as sql from

(select dp_login.name as login_name, dp_role.name as role_name from sys.database_role_members drm

inner join (select * from sys.database_principals dp where dp.type in (''S'',''U'') and dp.name not in (''dbo'', ''guest'', ''INFORMATION_SCHEMA'', ''sys'')) dp_login

on drm.member_principal_id = dp_login.principal_id

inner join (select * from sys.database_principals dp where dp.type=''R'' ) dp_role

on drm.role_principal_id = dp_role.principal_id ) ss'