Hi.. I am using SQL Server 2005.
I am Generating SQL Scripts to re-create all objects in a database.. to create a new database.
I know how to do this.. right-click on the database, Generate Scripts, script all objects, and change a few settings (Create Database, Object-Level Permissions, Triggers, etc.).
The one thing that does NOT get created are the non-admin Database level Roles. db_datareader, db_datawriter.
I need for these roles to get copied.. how can I generate my script to grant these on the new database?