Options Property
Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
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. |
Hinweise
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.