Export SQL Role

Hi,
Is there a way to export a database role.
I would like to generate a script that I can apply to
another server.. This script would essentially create this
role for me without me having to manually create it, with
all its permissions.
Thanks.Yes. Create a DTS Package Using Copy SQL Sever Objects Task. Go to the
Options button on the Copy tab and you'll see it. I've never used it, but
would assume it would copy permissions or else it would be no good IMO.
"niv" wrote:

> Hi,
> Is there a way to export a database role.
> I would like to generate a script that I can apply to
> another server.. This script would essentially create this
> role for me without me having to manually create it, with
> all its permissions.
> Thanks.
>