Tag: MS SQL Server Error Codes

SQL Server Error Code – 5834 the affinity specified conflicts with th

In this blog post, you’ll learn more about the SQL Server Error Code 5834 and the error message description that is shown SQL Server Error Code 5834 SQL Server Error Description for the Code :5834 The affinity specified conflicts with the IO affinity mask specified. Change the affinity setting to use different CPUs than those specified in the IO affinity mask.

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

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

SQL Server Error Code – 10104 cannot create %s_msg on view “%.*ls” bec

In this blog post, you’ll learn more about the SQL Server Error Code 10104 and the error message description that is shown SQL Server Error Code 10104 SQL Server Error Description for the Code :10104 Cannot create %S_MSG on view “%.*ls” because it references a table using a CONTAINSTABLE or FREETEXTTABLE full-text function. Consider removing use of these functions or not indexing the view.