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)

public enum CommandOptions

Member nameDescription
NoneNo specified options.
IncludeInsertColumnNamesIncludes column names in INSERT statements for the destination table.
BinaryParametersBinary parameters are used when propagating changes.

String literal values are used when BinaryParameters is not used.

DtsHorizontalPartitionThe 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.