共用方式為


Options Property

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

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

語法

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.

備註

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:

請參閱

參考