MSSQLSERVER_10531

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)