| title | MSSQLSERVER_10536 | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | supportability | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 9f97b41f-0ef8-4ad2-aec0-906a5d7522ba | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| manager | craigg |
| Product Name | SQL Server |
| Event ID | 10536 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | PG_TOO_MANY_STMTS |
| Message Text | Cannot create plan guide '%.*ls' because the batch or module corresponding to the specified @plan_handle contains more than 1000 eligible statements. Create a plan guide for each statement in the batch or module by specifying a statement_start_offset value for each statement. |
The batch or module corresponding to the specified @plan_handle contains more than 1000 eligible statements.
Create a plan guide for each statement in the batch or module by specifying a statement_start_offset value for each statement.
sp_create_plan_guide (Transact-SQL)
Plan Guides
sp_create_plan_guide_from_handle (Transact-SQL)