Skip to content

Commit 74c81d0

Browse files
committed
Add Mike's addition for error 556
1 parent 150402d commit 74c81d0

2 files changed

Lines changed: 49 additions & 0 deletions

File tree

Lines changed: 47 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,47 @@
1+
---
2+
description: "MSSQLSERVER_556"
3+
title: "MSSQLSERVER_556 | Microsoft Docs"
4+
ms.custom: ""
5+
ms.date: "09/15/2021"
6+
ms.prod: sql
7+
ms.reviewer: ""
8+
ms.technology: supportability
9+
ms.topic: "reference"
10+
helpviewer_keywords:
11+
- "556 (Database Engine error)"
12+
author: MikeRayMSFT
13+
ms.author: mikeray
14+
---
15+
# MSSQLSERVER_556
16+
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
17+
18+
## Details
19+
20+
| Attribute | Value |
21+
| :-------- | :---- |
22+
|Product Name|SQL Server|
23+
|Event ID|556|
24+
|Event Source|MSSQLSERVER|
25+
|Component|SQLEngine|
26+
|Symbolic Name|WRONGPAGE|
27+
|Message Text|INSERT EXEC failed because the stored procedure altered the schema of the target table.|
28+
29+
## Explanation
30+
31+
Query store is on.
32+
33+
The plan is removed after the query store fills up.
34+
35+
## User Action
36+
37+
Increase the size of the query store.
38+
39+
Clear the procedure cache when query store comes back from READ WRITE state
40+
41+
Recompile just the INSERT EXEC statement to force it to go through the regular compile path and avoid hitting this exception due to unplanned recomplilation caused by plan missing in query store.
42+
43+
For more information, see our [troubleshooting article on error 556](/troubleshoot/sql/database-design/error-556-insert-exec-failed).
44+
45+
## See Also
46+
[DBCC CHECKTABLE (Transact-SQL)](~/t-sql/database-console-commands/dbcc-checktable-transact-sql.md)
47+

docs/toc.yml

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -10514,6 +10514,8 @@ items:
1051410514
href: relational-databases/errors-events/mssqlserver-360-database-engine-error.md
1051510515
- name: 511
1051610516
href: relational-databases/errors-events/mssqlserver-511-database-engine-error.md
10517+
- name: 556
10518+
href: relational-databases/errors-events/mssqlserver-556-database-engine-error.md
1051710519
- name: 601
1051810520
href: relational-databases/errors-events/mssqlserver-601-database-engine-error.md
1051910521
- name: 605

0 commit comments

Comments
 (0)