Server option constants describe the behavior of a remote or linked server.
A RemoteServer object exposes the attributes of a Microsoft® SQL Server™ installation known as a remote server to another server. A LinkedServer object exposes the properties of an OLE DB data source, or linked server, allowing Transact-SQL queries against defined data sources.
| 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 publication Distributor for the local server (RemoteServer object only). |
| SQLDMOSrvOpt_Distributor | 8 | Referenced server is a replication Distributor (RemoteServer object only). |
| SQLDMOSrvOpt_DynamicParameters | 131072 | Referenced server recognizes the ODBC-specified ? character as a parameter representation in a query statement (LinkedServer object only). |
| SQLDMOSrvOpt_IndexAsAccessPath | 16384 | Provider-implemented indexes will be used as an access path for distributed queries against the referenced server (LinkedServer object only). |
| SQLDMOSrvOpt_InProcess | 8192 | Launches the OLE DB provider implementing the referenced data source as a COM in-process server (LinkedServer object only). |
| SQLDMOSrvOpt_LevelZeroOnly | 32768 | When accessing the referenced server, distributed queries use only OLE DB Level 0 support (LinkedServer object only). |
| SQLDMOSrvOpt_NestedQueries | 65536 | Referenced server supports the SELECT statement in the FROM clause of a query (LinkedServer object only). |
| SQLDMOSrvOpt_NonTransacted | 4096 | Distributed query allows 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. |
| SQLDMOSrvOpt_UseRemoteCollation | 1024 | Collation of remote columns is used for SQL Server data sources, and the collation specified in CollationName is used for non-SQL Server data sources (LinkedServer2 object only) |