Note
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang mag-sign in o magpalit ng mga direktoryo.
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang baguhin ang mga direktoryo.
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
Details
| Attribute | Value |
|---|---|
| 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
Plan Guides
sp_create_plan_guide (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)