SQL-DMO
Options Property
The Options property returns a bit-packed long integer that describes the attributes of a remote or linked server.
Applies To
Syntax
object.Options
Parts
object
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 | Referenced server uses ordering and character comparison identical to that used by the local server (LinkedServer object only). |
| SQLDMOSrvOpt_DataAccess | 128 | Referenced server is available to the local server as a distributed query participant (LinkedServer object only). |
| SQLDMOSrvOpt_DistPublisher | 16 | Referenced server is a distribution Publisher for the local server (RemoteServer object only). |
| SQLDMOSrvOpt_Distributor | 8 | Referenced server is a replication Distributor (RemoteServer object only). |
| SQLDMOSrvOpt_DynamicParameters | 16384 | 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 | Referenced server supports the SELECT statement in the FROM clause of a query (LinkedServer object only). |
| SQLDMOSrvOpt_NonTransacted | 512 | Distributed query will allow an update to the referenced server regardless of the presence of transaction support (LinkedServer object only). |
| SQLDMOSrvOpt_Publisher | 2 | 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 | Referenced server accepts remote procedure calls from the local server (LinkedServer object only). |
| SQLDMOSrvOpt_Subscriber | 4 | Referenced server subscribes to replication publications on the local server (RemoteServer object only). |
| SQLDMOSrvOpt_Unknown | 0 | No options set. |
Remarks
The RemoteServer object exposes the attributes of an instance of Microsoft® SQL Server™ 2000 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.