Tag: MS SQL Server Error Codes

SQL Server Error Code – 47130 creating contained availability group ‘%

In this blog post, you’ll learn more about the SQL Server Error Code 47130 and the error message description that is shown SQL Server Error Code 47130 SQL Server Error Description for the Code :47130 Creating contained availability group ‘%.*ls’ failed. When creating contained availability group, both master database and msdb database must be included in contained availability group. Include master and msdb in CREATE…

SQL Server Error Code – 4900 the alter table switch statement failed

In this blog post, you’ll learn more about the SQL Server Error Code 4900 and the error message description that is shown SQL Server Error Code 4900 SQL Server Error Description for the Code :4900 The ALTER TABLE SWITCH statement failed for table ‘%.*ls’. It is not possible to switch the partition of a table that has change tracking enabled. Disable change tracking before using…

SQL Server Error Code – 21538 table ‘%s’ cannot have table ‘%s’ as a p

In this blog post, you’ll learn more about the SQL Server Error Code 21538 and the error message description that is shown SQL Server Error Code 21538 SQL Server Error Description for the Code :21538 Table ‘%s’ cannot have table ‘%s’ as a parent in a logical record relationship because it already has a different parent table. A logical record relationship allows only one parent…

SQL Server Error Code – 2202 %san error has occurred while compiling

In this blog post, you’ll learn more about the SQL Server Error Code 2202 and the error message description that is shown SQL Server Error Code 2202 SQL Server Error Description for the Code :2202 %sAn error has occurred while compiling the query. To obtain more detailed information about the error, the query must be run by a user with EXECUTE permissions on the xml…