Replication script constants control Transact-SQL command batch contents for the Script method of a SQL-DMO object representing a replication component.
| Constant | Value | Description |
|---|---|---|
| SQLDMORepScript_AnsiFile | 16777216 | Output to a file is written as ANSI character text. |
| SQLDMORepScript_AppendToFile | 8192 | Output is appended to a designated operating system file. If not set, output overwrites any data in an existing, designated file. |
| SQLDMORepScript_Creation | 16384 | Script includes database object creation. |
| SQLDMORepScript_Default | 256 | SQLDMORepScript_InstallDistributor. |
| SQLDMORepScript_Deletion | 32768 | Script includes deletion of existing database objects. |
| SQLDMORepScript_DisableReplicationDB | 134217728 | Script disables a replication database. |
| SQLDMORepScript_EnableReplicationDB | 67108864 | Script enables a replication database. |
| SQLDMORepScript_InstallDistributor | 256 | Default. The script installs the replication Distributor. |
| SQLDMORepScript_InstallPublisher | 1024 | Script installs a Publisher. |
| SQLDMORepScript_InstallReplication | 1048576 | Script installs replication. |
| SQLDMORepScript_NoCommandTerm | 268435456 | No command terminator is added to script commands. |
| SQLDMORepScript_NoSubscription | 128 | Script creation of publication, excluding push subscriptions. |
| SQLDMORepScript_PublicationCreation | 65536 | Script includes publication creation text. |
| SQLDMORepScript_PublicationDeletion | 131072 | Script includes text that removes publications. |
| SQLDMORepScript_PullSubscriptionCreation | 262144 | Script pull subscription creation. |
| SQLDMORepScript_PullSubscriptionDeletion | 524288 | Script pull subscription deletion. |
| SQLDMORepScript_ReplicationJobs | 4194304 | Script creation of replication-related jobs to preserve job schedule and steps. The corresponding job script must be run before the replication script. This constant can only be used with Microsoft® SQL Server™ 2000. Only a member of the sysadmin fixed server role or the owner of a job have access to a job creation script. |
| SQLDMORepScript_SubscriptionCreation | 262144 | Obsolete. |
| SQLDMORepScript_SubscriptionDeletion | 524288 | Obsolete. |
| SQLDMORepScript_ToFileOnly | 4096 | Output generated by an executed script is directed to an operating system file only. If not set, output is available as status or error messages. |
| SQLDMORepScript_UnicodeFile | 33554432 | Output to a file is written as Unicode character text. |
| SQLDMORepScript_UninstallDistributor | 512 | Script removes the replication Distributor. |
| SQLDMORepScript_UninstallPublisher | 2048 | Script removes a Publisher. |
| SQLDMORepScript_UninstallReplication | 2097152 | Script removes replication. |