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)

Syntax

'Declaration
<FlagsAttribute> _
Public Enumeration CommandOptions
'Usage
Dim instance As CommandOptions
[FlagsAttribute]
public enum CommandOptions
[FlagsAttribute]
public enum class CommandOptions
[<FlagsAttribute>]
type CommandOptions
public enum CommandOptions

Members

Member name Description
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.

IncludeInsertColumnNames Includes column names in INSERT statements for the destination table.
None No specified options.

See Also

Reference

Microsoft.SqlServer.Replication Namespace

Other Resources

Specify How Changes Are Propagated for Transactional Articles