| title | MSSQLSERVER_10531 | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 04/04/2017 | |
| ms.prod | sql | |
| ms.reviewer | ||
| ms.technology | supportability | |
| ms.topic | language-reference | |
| helpviewer_keywords |
|
|
| ms.assetid | bb40e994-231c-44ce-933f-8d767fb2f450 | |
| author | MashaMSFT | |
| ms.author | mathoma |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
| 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. |
The user does not have adequate permissions to create the specified plan guide from the plan cache.
Grant VIEW SERVER STATE permission to the user creating the plan guide.
Plan Guides
sp_create_plan_guide (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)