Tag: MS SQL Server Error Codes

SQL Server Error Code – 1710 cannot use alias type with rule or defau

In this blog post, you’ll learn more about the SQL Server Error Code 1710 and the error message description that is shown SQL Server Error Code 1710 SQL Server Error Description for the Code :1710 Cannot use alias type with rule or default bound to it as a column type in table variable or return table definition in table valued function. Type ?%.*ls? has a…

SQL Server Error Code – 8673 a merge statement is not valid if it tri

In this blog post, you’ll learn more about the SQL Server Error Code 8673 and the error message description that is shown SQL Server Error Code 8673 SQL Server Error Description for the Code :8673 A MERGE statement is not valid if it triggers both the ‘ON DELETE SET NULL’ and ‘ON UPDATE CASCADE’ actions for a referential integrity constraint. Modify the actions performed by…

SQL Server Error Code – 6994 invalid restriction for type ‘%s’. the a

In this blog post, you’ll learn more about the SQL Server Error Code 6994 and the error message description that is shown SQL Server Error Code 6994 SQL Server Error Description for the Code :6994 Invalid restriction for type ‘%s’. The attribute wildcard in the restricted type must be a valid subset of the corresponding attribute wildcard in the base type, and the processContents may…

SQL Server Error Code – 4948 alter table switch statement failed. the

In this blog post, you’ll learn more about the SQL Server Error Code 4948 and the error message description that is shown SQL Server Error Code 4948 SQL Server Error Description for the Code :4948 ALTER TABLE SWITCH statement failed. The source table ‘%.*ls’ is in database ‘%.*ls’ while the target table ‘%.*ls’ is in database ‘%.*ls’.

SQL Server Error Code – 47107 the %ls operation is not allowed by the

In this blog post, you’ll learn more about the SQL Server Error Code 47107 and the error message description that is shown SQL Server Error Code 47107 SQL Server Error Description for the Code :47107 The %ls operation is not allowed by the current availability group configuration. The availability group ‘%.*ls’ only supports one relica which has configuration-only availability mode. Verify that the specified availability…