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



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.

© 2016 Microsoft