Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Execution Location Property

Execution Location Property

SQL Server 2000

Execution Location Property

This property determines the location of query resolution: the client application, server, or a combination of both.

Property Name

Execution Location

Property ID

DBPROP_MSMD_EXECLOCATION

Remarks

The following values are available.

Value Description
0 Default. For compatibility with earlier versions, this means the same as Value 1. The meaning of this default value is subject to change in future versions.
1 PivotTable® Service selects the query execution location (client application or server) that will provide the best performance.
2 Queries are executed on the client application.
3 Queries are executed on the server. (Queries that contain session-scoped calculated members, user-defined sets, or user-defined functions are exceptions.)

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

Show:
© 2015 Microsoft