| title |
MSSQLSERVER_10539 | Microsoft Docs |
| ms.custom |
|
| ms.date |
03/06/2017 |
| ms.prod |
sql-server-2014 |
| ms.reviewer |
|
| ms.technology |
supportability |
| ms.topic |
conceptual |
| helpviewer_keywords |
10539 (Database Engine error) |
|
| ms.assetid |
49c26ff7-18b8-4f07-a087-f45f63463b3b |
| author |
MashaMSFT |
| ms.author |
mathoma |
| manager |
craigg |
|
|
| Product Name |
SQL Server |
| Event ID |
10539 |
| Event Source |
MSSQLSERVER |
| Component |
SQLEngine |
| Symbolic Name |
PG_NO_PLAN_FOR_STMT |
| Message Text |
Cannot create plan guide '%.*ls' from cache because a query plan is not available for the statement with start offset %d. This problem can occur if the statement depends on database objects that have not yet been created. Make sure that all necessary database objects exist, and execute the statement before creating the plan guide. |
A query plan is not available in the plan cache for the statement with the specified starting offset.
Make sure that all necessary database objects exist, and execute the statement before creating the plan guide.
sp_create_plan_guide_from_handle (Transact-SQL)