Edit

MSSQLSERVER_10509

  • Article

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

Details

Attribute Value
Product Name SQL Server
Event ID 10509
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name PG_INVALID_STMT
Message Text Cannot create plan guide '%.*ls' because the statement specified by @stmt or @statement_start_offset either contains a syntax error or is ineligible for use in a plan guide. Provide a single valid Transact-SQL statement or a valid starting position of the statement within the batch. To obtain a valid starting position, query the statement_start_offset column in the sys.dm_exec_query_stats dynamic management function.

Explanation

The statement specified by @stmt or @statement_start_offset either contains a syntax error or is ineligible for use in a plan guide.

User Action

Provide a single valid Transact-SQL statement or a valid starting position of the statement within the batch. To obtain a valid starting position, query the statement_start_offset column in the sys.dm_exec_query_stats dynamic management function.

See Also

sp_create_plan_guide (Transact-SQL)
Plan Guides
sys.dm_exec_query_stats (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)