Category: SQL Server

SQL Server Error Code – 3822 warning: the heap ?%.*ls?.?%.*ls? has pe

In this blog post, you’ll learn more about the SQL Server Error Code 3822 and the error message description that is shown SQL Server Error Code 3822 SQL Server Error Description for the Code :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…

SQL Server Error Code – 3735 the primary key constraint ?%.*ls? on ta

In this blog post, you’ll learn more about the SQL Server Error Code 3735 and the error message description that is shown SQL Server Error Code 3735 SQL Server Error Description for the Code :3735 The primary key constraint ?%.*ls? on table ?%.*ls? cannot be dropped because change tracking is enabled on the table. Change tracking requires a primary key constraint on the table. Disable…