You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
|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).
0 commit comments