Server option constants describe the behavior of a remote or linked server.
A RemoteServer object exposes the attributes of an Microsoft® SQL Server™ installation that is 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 | 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 distributed queries 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, distributed queries 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 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 |
| Options Property | SetOptions Method |