Enables or prevents users from accessing query plans from the Interactive SQL client or from using SQL functions to get plans.
DBA permissions are required to modify this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
When QUERY_PLAN_TEXT_ACCESS option is ON, users can view, save, and print query plans from the Interactive SQL client. When the option is OFF, query plans are not cached, and other query plan-related database options have no affect on the query plan display from the Interactive SQL client. This error message displays:
No plan available. The database option QUERY_PLAN_TEXT_ACCESS is OFF.