Replication Script Constants (SQLDMO_REPSCRIPT_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Replication script constants control Transact-SQL command batch contents for the Script method of a SQL Distributed Management Objects (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 this option is not setoutput overwrites any data in an existing, designated file. |
SQLDMORepScript_Creation |
16384 |
The script includes database object creation. |
SQLDMORepScript_Default |
256 |
SQLDMORepScript_InstallDistributor. |
SQLDMORepScript_Deletion |
32768 |
The script includes deletion of existing database objects. |
SQLDMORepScript_/DisableReplicationDB |
134217728 |
The script disables a replication database. |
SQLDMORepScript_/EnableReplicationDB |
67108864 |
The script enables a replication database. |
SQLDMORepScript_/InstallDistributor |
256 |
Default. The script installs the replication Distributor. |
SQLDMORepScript_/InstallPublisher |
1024 |
The script installs a Publisher. |
SQLDMORepScript_/InstallReplication |
1048576 |
The script installs replication. |
SQLDMORepScript_/NoCommandTerm |
268435456 |
No command terminator is added to script commands. |
SQLDMORepScript_/NoSubscription |
128 |
Scripts creation of publication, excluding push subscriptions. |
SQLDMORepScript_/PublicationCreation |
65536 |
The script includes publication creation text. |
SQLDMORepScript_/PublicationDeletion |
131072 |
The script includes text that removes publications. |
SQLDMORepScript_/PullSubscriptionCreation |
262144 |
Scripts pull subscription creation. |
SQLDMORepScript_/PullSubscriptionDeletion |
524288 |
Scripts pull subscription deletion. |
SQLDMORepScript_/ReplicationJobs |
4194304 |
The script creates 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 and later Only a member of the sysadmin fixed server role or the owner of a job has 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 this option is 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 |
The script removes the replication Distributor. |
SQLDMORepScript_/UninstallPublisher |
2048 |
The script removes a Publisher. |
SQLDMORepScript_/UninstallReplication |
2097152 |
The script removes replication. |