Tag: MS SQL Server Error Codes

SQL Server Error Code – 20670 cannot add, drop, or alter the identity

In this blog post, you’ll learn more about the SQL Server Error Code 20670 and the error message description that is shown SQL Server Error Code 20670 SQL Server Error Description for the Code :20670 Cannot add, drop, or alter the identity range check constraint for table %s. This constraint is used by replication for automatic identity range management. This error typically occurs if the…

SQL Server Error Code – 1426 to issue alter database set witness, all

In this blog post, you’ll learn more about the SQL Server Error Code 1426 and the error message description that is shown SQL Server Error Code 1426 SQL Server Error Description for the Code :1426 To issue ALTER DATABASE SET WITNESS, all three server instances must be interconnected, and the mirror database must be caught up. When these conditions are met, reissue the command.

SQL Server Error Code – 47102 the cluster type of availability group ‘

In this blog post, you’ll learn more about the SQL Server Error Code 47102 and the error message description that is shown SQL Server Error Code 47102 SQL Server Error Description for the Code :47102 The cluster type of availability group ‘%.*ls’ only supports EXTERNAL failover mode.  Verify that the specified availability group cluster type is correct, then retry the operation.