SQL Server Error Msg 3822 – Warning: The heap “%.*ls”.”%.*ls” has persisted computed columns that depends on a geometry or geography methods and may contain out-of-date information. Because of this, DBCC may report inconsistencies on this table.  The persisted computed columns depending on geometry or geography methods should be unpersisted and persisted again to refresh the data.

In this blog post, let’s learn about the error message “3822 – Warning: The heap “%.*ls”.”%.*ls” has persisted computed columns that depends on a geometry or geography methods and may contain out-of-date information. Because of this, DBCC may report inconsistencies on this table.  The persisted computed columns depending on geometry or geography methods should be unpersisted and persisted again to refresh the data.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

3822 – Warning: The heap “%.*ls”.”%.*ls” has persisted computed columns that depends on a geometry or geography methods and may contain out-of-date information. Because of this, DBCC may report inconsistencies on this table.  The persisted computed columns depending on geometry or geography methods should be unpersisted and persisted again to refresh the data.

Reason for the Error

To be update soon…

Solution

To be update soon…