>>In the old SQL Enterprise Manager there was a scripting option that would script the object's permissions along with the object scripting when the object was scripted by EM.
>>
>>I have found no way to get SQL Management Studio to do this. Is there a way and if so, how?
>>
>>Thanks,
>>Bill
>
>Right Click on Table (or other object). Select Properties, Go to Permissions node of the treeview. Click on Script Button.
Hi Borissov,
Thanks, yes, I am familiar with this. What I want is when I select for the IDE to script an object ( E.g. a Stored Proc ), the scripting engine will script the object permissions at the same time like Query Analyzer used to do.
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.