--Roles de la Base de Datos

SELECT 
	'CREATE ROLE [' + dbU.[name] + '];'
FROM	
	sys.database_principals AS dbU 	
WHERE TYPE = 'R' AND is_fixed_role = 0
GO