February 1, 2011 at 9:04 am
hi, do any of you have a script to script server roles and permissions, i know i can script database roles by righ clicking database but i need ONLY server roles and permissions such as sysadmins, diskadmin, etc.
February 1, 2011 at 10:26 am
I've used a script in the past that I can't seem to find right now, however, a search of the script section here at SSC shows a couple of scripts for listing server roles and/or db roles.
http://www.sqlservercentral.com/search/?q=server+roles&t=s
Greg
February 1, 2011 at 10:30 am
Not sure why you would want to do this since these roles are created when you install SQL Server. However, you can find the script to create these roles inside the "u_tables.sql" file. On a default instance this file is located in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install folder.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply