Options Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The Options property returns a bit-packed long integer that describes the attributes of a remote or linked server.
Syntax
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. |
Remarks
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.