In the Enterprise Manager (EM), right click on the source database (DB) and slect AllTasks -> Generate SQL Script, select Options tab, check Script database users and database roles, select File Format and click OK to generate a script. Review the script generated, make neccessary adjustments and run it for destination DB.
>Good morning! Does anyone know how I can copy the security roles of one database to another database in the same server?
>
--sb--