MSSQLSERVER_10531

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

Product Name

SQL Server

Event ID

10531

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

PG_NO_ELIGIBLE_STMT

Message Text

Cannot create plan guide '%.*ls' from cache because the user does not have adequate permissions. Grant the VIEW SERVER STATE permission to the user creating the plan guide.

Explanation

The user does not have adequate permissions to create the specified plan guide from the plan cache.

User Action

Grant VIEW SERVER STATE permission to the user creating the plan guide.

See Also

Reference

sp_create_plan_guide (Transact-SQL)

sp_create_plan_guide_from_handle (Transact-SQL)

Concepts

Plan Guides