mssqlserver-10536-database-engine-error.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
MSSQLSERVER_10536	MSSQLSERVER_10536	MashaMSFT	mathoma	04/04/2017	sql	supportability	reference	10536 (Database Engine error)

MSSQLSERVER_10536

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]

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)