Server Option Constants (SQLDMO_SRVOPTION_TYPE)
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.
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 |
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 publication Distributor for the local server (RemoteServer object only). |
SQLDMOSrvOpt_Distributor |
8 |
The referenced server is a replication Distributor (RemoteServer object only). |
SQLDMOSrvOpt_/DynamicParameters |
131072 |
The referenced server recognizes the ODBC-specified ? character as a parameter representation in a query statement (LinkedServer object only). |
SQLDMOSrvOpt_/IndexAsAccessPath |
16384 |
Provider-implemented indexes are 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 Component Object Model (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 |
The referenced server supports the SELECT statement in the FROM clause of a query (LinkedServer object only). |
SQLDMOSrvOpt_NonTransacted |
4096 |
The distributed query allows updates 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 (RPCs) made by the remote or linked server. |
SQLDMOSrvOpt_RPC_out |
64 |
The referenced server accepts RPCs 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. |
SQLDMOSrvOpt_/UseRemoteCollation |
1024 |
Collation of remote columns is used for SQL Server data sources, and the collation specified in CollationName is used for data sources other than SQL Server data sources LinkedServer2 object only) |