RE: Export SQL Role

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: ChrisR (ChrisR_at_discussions.microsoft.com)
Date: 10/22/04 

Date: Fri, 22 Oct 2004 10:35:03 -0700

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.
>

Quantcast