Generate SQL Scripts, General Tab
The following options are available on the General tab of the Generate SQL Scripts dialog box.
Options
Distributor properties
Script the configuration of the Distributor. If the server is both a Publisher and Distributor, the script includes all configurations. If the server is just a Publisher, the script contains just the pointer to the Distributor.
Publications in these databases
Script the publications in the selected databases.
Pull Subscriptions in these selected databases
Script the pull subscriptions in the selected databases.
All
Select all the databases in the list.
None
Clear all the databases in the list.
Enable or create the selected components
Script the steps to enable or create the components in the selected databases. Also adds a Distributor, if that is selected.
Disable or drop the selected components
Script the steps to disable or drop the components in the selected databases. Also drops a Distributor, if that is selected. Scripting these steps will not drop the publications or pull subscriptions or disable the Distributor.
Script creation of replication jobs
If selected, SQL Server Enterprise Manager will attempt to create scripts of replication jobs along with configuration of the Distributor, publications, or pull subscriptions if indicated. However, you do not have privileges to view jobs using msdb.dbo.sp_help_job, SQL Server Enterprise Manager may fail to create the job script. Typically, members of the sysadmin fixed server role or the owner of jobs have privilege to view jobs using msdb.dbo.sp_help_job. This option is not available for servers running SQL Server 7.0 or earlier versions.
Preview
Preview and modify the script before it is saved. If you make changes to the preview script, you must click Save As in the Preview dialog box to save those changes.