| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|
MSSQLSERVER_10507 |
MSSQLSERVER_10507 |
MashaMSFT |
mathoma |
04/04/2017 |
sql |
supportability |
reference |
|
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 10507 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | PG_STMT_DOES_NOT_MATCH |
| Message Text | Cannot create plan guide '%.*ls' because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, does not match any statement in the specified module or batch. Modify the values to match a statement in the module or batch. |
A statement in the specified module or batch could not be matched to the specified statement or statement offset value.
Modify the specified parameter values to match a statement in the module or batch.
Plan Guides
sp_create_plan_guide (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)