Tag: MS SQL Server Error Codes

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

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

SQL Server Error Code – 13767 the clustered index ‘%.*ls’ is being use

In this blog post, you’ll learn more about the SQL Server Error Code 13767 and the error message description that is shown SQL Server Error Code 13767 SQL Server Error Description for the Code :13767 The clustered index ‘%.*ls’ is being used for automatic cleanup of aged data, and can be converted to either a clustered columnstore or B-tree index starting with the column that…

SQL Server Error Code – 35316 the statement failed because a columnsto

In this blog post, you’ll learn more about the SQL Server Error Code 35316 and the error message description that is shown SQL Server Error Code 35316 SQL Server Error Description for the Code :35316 The statement failed because a columnstore index must be partition-aligned with the base table. Create the columnstore index using the same partition function and same (or equivalent) partition scheme as…

SQL Server Error Code – 19502 cannot create a distributed availability

In this blog post, you’ll learn more about the SQL Server Error Code 19502 and the error message description that is shown SQL Server Error Code 19502 SQL Server Error Description for the Code :19502 Cannot create a distributed availability replica for availability group ‘%.*ls’.  An availability replica of the specified availability group already exists on this instance of SQL Server.  Verify that the specified…