Category: SQL Server

SQL Server Error Code – 20639 cannot enable the publication to support

In this blog post, you’ll learn more about the SQL Server Error Code 20639 and the error message description that is shown SQL Server Error Code 20639 SQL Server Error Description for the Code :20639 Cannot enable the publication to support non-SQL Server subscriptions because the publication is enabled for updatable subscriptions. To support non-SQL Server subscriptions, drop the existing publication and create a new…

SQL Server Error Code – 13536 cannot insert an explicit value into a g

In this blog post, you’ll learn more about the SQL Server Error Code 13536 and the error message description that is shown SQL Server Error Code 13536 SQL Server Error Description for the Code :13536 Cannot insert an explicit value into a GENERATED ALWAYS column in table ‘%.*ls’. Use INSERT with a column list to exclude the GENERATED ALWAYS column, or insert a DEFAULT into…

SQL Server Error Code – 21803 cannot update agent parameter metadata.

In this blog post, you’ll learn more about the SQL Server Error Code 21803 and the error message description that is shown SQL Server Error Code 21803 SQL Server Error Description for the Code :21803 Cannot update agent parameter metadata. Replication could not insert parameter ‘%s’ into table ‘%s’. Verify that replication is properly installed. Check errors returned by SQL Server during execution of sp_createagentparameter.

SQL Server Error Code – 8982 table error: cross object linkage. page

In this blog post, you’ll learn more about the SQL Server Error Code 8982 and the error message description that is shown SQL Server Error Code 8982 SQL Server Error Description for the Code :8982 Table error: Cross object linkage. Page %S_PGID->next in object ID %d, index ID %d, partition ID %I64d, AU ID %I64d (type %.*ls) refers to page %S_PGID in object ID %d,…

SQL Server Error Code – 965 warning: a column nullability inconsiste

In this blog post, you’ll learn more about the SQL Server Error Code 965 and the error message description that is shown SQL Server Error Code 965 SQL Server Error Description for the Code :965 Warning: A column nullability inconsistency was detected in the metadata of index ?%.*ls? (index_id = %d) on object ID %d in database ?%.*ls?. The index may be corrupt. Run DBCC…

SQL Server Error Code – 4982 alter table switch statement failed. che

In this blog post, you’ll learn more about the SQL Server Error Code 4982 and the error message description that is shown SQL Server Error Code 4982 SQL Server Error Description for the Code :4982 ALTER TABLE SWITCH statement failed. Check constraints of source table ‘%.*ls’ allow values that are not allowed by range defined by partition %d on target table ‘%.*ls’.