| title | MSSQLSERVER_10509 | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/06/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | supportability | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | e9dd5357-ee3d-420a-9a89-d12ab5404e73 | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| manager | craigg |
| 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 [!INCLUDEtsql] 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. |
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 [!INCLUDEtsql] 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.
sp_create_plan_guide (Transact-SQL)
Plan Guides
sys.dm_exec_query_stats (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)