Compartir a través de


Options Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The Options property returns a bit-packed long integer that describes the attributes of a remote or linked server.

Sintaxis

object
.Options

Parts

  • object
    An expression that evaluates to an object in the Applies To list

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetOptions(SQLOLE_SRVOPTION_TYPE* pRetVal);

Returns

Interpret the return value using this information.

Constant

Value

Description

SQLDMOSrvOpt/_CollationCompatible

256

The referenced server uses ordering and character comparison identical to that used by the local server (LinkedServer object only).

SQLDMOSrvOpt_DataAccess

128

The referenced server is available to the local server as a distributed query participant (LinkedServer object only).

SQLDMOSrvOpt_DistPublisher

16

The referenced server is a distribution Publisher for the local server (RemoteServer object only).

SQLDMOSrvOpt_Distributor

8

The referenced server is a replication Distributor (RemoteServer object only).

SQLDMOSrvOpt/_DynamicParameters

16384

The referenced server recognizes the ODBC-specified character ? as a parameter representation in a query statement (LinkedServer object only).

SQLDMOSrvOpt/_IndexAsAccessPath

2048

Provider-implemented indexes will be used as an access path for a distributed query against the referenced server (LinkedServer object only).

SQLDMOSrvOpt_InProcess

1024

Launches the OLE DB provider implementing the referenced data source as a COM in-process server (LinkedServer object only).

SQLDMOSrvOpt_/LevelZeroOnly

4096

When accessing the referenced server, a distributed query will use only OLE DB Level 0 support (LinkedServer object only).

SQLDMOSrvOpt_/NestedQueries

8192

The referenced server supports the SELECT statement in the FROM clause of a query (LinkedServer object only).

SQLDMOSrvOpt_/NonTransacted

512

The distributed query will allow an update to the referenced server regardless of the presence of transaction support (LinkedServer object only).

SQLDMOSrvOpt_Publisher

2

The referenced server publishes data to the local server (RemoteServer object only).

SQLDMOSrvOpt_RPC

1

Allows remote procedure calls made by the remote or linked server.

SQLDMOSrvOpt_RPC_out

64

The referenced server accepts remote procedure calls from the local server (LinkedServer object only).

SQLDMOSrvOpt_Subscriber

4

The referenced server subscribes to replication publications on the local server (RemoteServer object only).

SQLDMOSrvOpt_Unknown

0

No options are set.

Comentarios

The RemoteServer object exposes the attributes of an instance of Microsoft SQL Server known as a remote server to another server. A LinkedServer object exposes the properties of an OLE DB data source (linked server), allowing Transact-SQL queries against defined data sources.

Use the SetOptions method to set attributes for a remote or linked server.

Applies To:

Vea también

Referencia