CommandOptions Enumeration

Enumerates options that control how changes are propagated for transactional articles.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)


<FlagsAttribute> _
Public Enumeration CommandOptions
Dim instance As CommandOptions
public enum CommandOptions
public enum class CommandOptions
type CommandOptions
public enum CommandOptions


Member name Description
None No specified options.
IncludeInsertColumnNames Includes column names in INSERT statements for the destination table.
BinaryParameters Binary parameters are used when propagating changes.

String literal values are used when BinaryParameters is not used.

DtsHorizontalPartition The horizontal partition for the article is defined by a transformable subscription.

The transformable subscriptions feature for transactional replication has been deprecated. Support for this feature in the user interface has been dropped. Using the feature requires installation of SQL Server 2000 Data Transformation Services (DTS), which is not installed by default with Microsoft SQL Server 2005. You must select it in the Advanced page of the Installation Wizard feature tree during setup or upgrade from a SQL Server 2000 installation that included DTS. See SQL Server 2000 documentation for information about this feature.


This namespace, class, or member is supported only in the Microsoft .NET Framework version 2.0.