CommandOptions Property (SQL-DMO)

The CommandOptions property controls Transact-SQL statement generation and stored procedure parameter binding for data and stored procedures replicated by the referenced transactional article.

Applies To

TransArticle Object

Syntax

object.CommandOptions [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value Long integer specifying command generation behavior as described in Settings

Settings
Constant Value Description
SQLDMOCommandOption_
IncludeInsertColumnNames
8 Include column names in destination-table INSERT statements
SQLDMOCommandOption_
BinaryParameters
16 Send the stored procedure parameters in binary format

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetCommandOptions(
SQLDMO_COMMANDOPTION_TYPE FAR * pRetVal);

HRESULT SetCommandOptions(
SQLDMO_COMMANDOPTION_TYPE NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.