The Options property returns a bit-packed long integer describing the attributes of a remote or linked server.
| LinkedServer Object | RemoteServer Object |
object.Options
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
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 |
The RemoteServer object exposes the attributes of an server running Microsoft® SQL Server™ that is 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.
Long, enumerated
Read-only
HRESULT GetOptions(SQLOLE_SRVOPTION_TYPE* pRetVal);