Server Option Constants (SQLDMO_SRVOPTION_TYPE)

SQL-DMO

SQL-DMO

Server Option Constants (SQLDMO_SRVOPTION_TYPE)

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)

See Also

SetOptions Method