Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
Details
| Attribute | Value |
|---|---|
| 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. |
Explanation
The batch or module corresponding to the specified @plan_handle contains more than 1000 eligible statements.
User Action
Create a plan guide for each statement in the batch or module by specifying a statement_start_offset value for each statement.
See Also
sp_create_plan_guide (Transact-SQL)
Plan Guides
sp_create_plan_guide_from_handle (Transact-SQL)