DBPROP_MSMD_EXECLOCATION Property

Determines the location of query resolution: the client, server, or a combination of both.

Remarks

This property’s name, which is used in the connection string, is Execution Location.

Four values are available:

• 0: default; currently equivalent to 1, but subject to change in future versions.
• 1: automatic selection of query execution location, either client or server.
• 2: query execution location is the client.
• 3: query execution location is the server. (There are several exceptions, including queries that contain session-scoped calculated members, user-defined sets, or user-defined functions.)

This property’s value is used when a session is established, and the value can be changed during the session.