Category: SQL Server

SQL Server Error Code – 4977 alter table switch statement failed. tar

In this blog post, you’ll learn more about the SQL Server Error Code 4977 and the error message description that is shown SQL Server Error Code 4977 SQL Server Error Description for the Code :4977 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a check constraint ‘%.*ls’ on a CLR type column, but the source table ‘%.*ls’ does not have an identical check constraint.

SQL Server Error Code – 13731 system-versioned table schema modificati

In this blog post, you’ll learn more about the SQL Server Error Code 13731 and the error message description that is shown SQL Server Error Code 13731 SQL Server Error Description for the Code :13731 System-versioned table schema modification failed because column ‘%.*ls’ in history table ‘%.*ls’ corresponds to a generated always column in table ‘%.*ls’ and cannot be nullable.

SQL Server Error Code – 41171 failed to create availability group ‘%.*

In this blog post, you’ll learn more about the SQL Server Error Code 41171 and the error message description that is shown SQL Server Error Code 41171 SQL Server Error Description for the Code :41171 Failed to create availability group ‘%.*ls’, because a Windows Server Failover Cluster (WSFC) group with the specified name already exists.  The operation has been rolled back successfully.  To retry creating…

SQL Server Error Code – 21640 non-sql server publishers do not support

In this blog post, you’ll learn more about the SQL Server Error Code 21640 and the error message description that is shown SQL Server Error Code 21640 SQL Server Error Description for the Code :21640 Non-SQL Server Publishers do not support a value of 1 for the parameter @thirdparty_flag. When executing the stored procedure sp_adddistpublisher, specify a value of 0 for the parameter.