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.