Skip to content

Latest commit

 

History

History
39 lines (33 loc) · 1.58 KB

File metadata and controls

39 lines (33 loc) · 1.58 KB
title MSSQLSERVER_10536 | Microsoft Docs
ms.custom
ms.date 04/04/2017
ms.prod sql
ms.reviewer
ms.technology supportability
ms.topic language-reference
helpviewer_keywords
10536 (Database Engine error)
ms.assetid 9f97b41f-0ef8-4ad2-aec0-906a5d7522ba
author MashaMSFT
ms.author mathoma

MSSQLSERVER_10536

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

Details

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)