AFAIK, object level permissions will only be scripted when
you script the object and select Script Object Level
Statement level permissions will be scripted with the role
though if you select Script object level permissions - even
if you haven't selected any objects. May not make much sense
but that's how it seems to work.
If you don't want to do something where you include the
objects and then delete those out of the script, you may
need to just write your own script.
On Wed, 10 Jul 2002 07:59:48 -0700, "Nick Collins"
>Is it possible to rename or create a copy of a user-
>defined role in SQL Server 2000? I tried to generate a
>SQL script, but the permissions are not generated with the
>Thank you in advance.
>Blue Cross Blue Shield of Michigan