Category: SQL Server

SQL Server Error Code – 22119 cannot enable change tracking on table ‘

In this blog post, you’ll learn more about the SQL Server Error Code 22119 and the error message description that is shown SQL Server Error Code 22119 SQL Server Error Description for the Code :22119 Cannot enable change tracking on table ‘%.*ls’. Change tracking requires a primary key constraint on the table to be enabled. Enable the primary key constraint on the table before enabling…

SQL Server Error Code – 33579 cannot drop a value for the column encry

In this blog post, you’ll learn more about the SQL Server Error Code 33579 and the error message description that is shown SQL Server Error Code 33579 SQL Server Error Description for the Code :33579 Cannot drop a value for the column encryption key ‘%.*ls’; dropping the value makes the key enclave disabled, and one or more objects that are schema-bound to column ‘%.*ls’ depend…

SQL Server Error Code – 8398 the use of more than two-part column nam

In this blog post, you’ll learn more about the SQL Server Error Code 8398 and the error message description that is shown SQL Server Error Code 8398 SQL Server Error Description for the Code :8398 The use of more than two-part column names will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify…

SQL Server Error Code – 18782 could not locate backup header informati

In this blog post, you’ll learn more about the SQL Server Error Code 18782 and the error message description that is shown SQL Server Error Code 18782 SQL Server Error Description for the Code :18782 Could not locate backup header information for database ‘%s’ in the specified backup device. Specify a backup device that contains a backup of the Publisher database.

SQL Server Error Code – 3448 rollback encountered a page with a log s

In this blog post, you’ll learn more about the SQL Server Error Code 3448 and the error message description that is shown SQL Server Error Code 3448 SQL Server Error Description for the Code :3448 Rollback encountered a page with a log sequence number (LSN) less than the original log record LSN. Could not undo log record %S_LSN, for transaction ID %S_XID, on page %S_PGID,…

SQL Server Error Code – 8527 an attempt to create a distributed trans

In this blog post, you’ll learn more about the SQL Server Error Code 8527 and the error message description that is shown SQL Server Error Code 8527 SQL Server Error Description for the Code :8527 An attempt to create a distributed transaction export token failed with this error: %ls. Contact your Microsoft Distributed Transaction Coordinator (MS DTC) system administrator.

SQL Server Error Code – 22835 could not update the metadata for databa

In this blog post, you’ll learn more about the SQL Server Error Code 22835 and the error message description that is shown SQL Server Error Code 22835 SQL Server Error Description for the Code :22835 Could not update the metadata for database %s to indicate that a Change Data Capture job has been dropped. The failure occurred when executing the command ‘%s’. The error returned…

SQL Server Error Code – 35396 effective dop of %u is too high for colu

In this blog post, you’ll learn more about the SQL Server Error Code 35396 and the error message description that is shown SQL Server Error Code 35396 SQL Server Error Description for the Code :35396 Effective DOP of %u is too high for columnstore compression on table id %d because each thread only has %I64d KB for compression. Please retry using the MAXDOP hint to…