Redigera

Dela via


MSSQLSERVER_10531

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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)