-zp database server option

dbsrv16 -zp ...

All operating systems and database servers.

Include this option if you want the database server to store the query execution plan that was used most recently by each connection. This feature can also be turned on using the RememberLastPlan server setting with the sa_server_option system procedure. You can view the text of the most recently-used plan by using the LastPlanText connection property.

-zp database server option

Syntax

Applies to

Remarks

See also