Category: SQL Server

SQL Server Error Code – 21506 sp_mergecompletecleanup cannot be execut

In this blog post, you’ll learn more about the SQL Server Error Code 21506 and the error message description that is shown SQL Server Error Code 21506 SQL Server Error Description for the Code :21506 sp_mergecompletecleanup cannot be executed before sp_mergepreparecleanup is executed. Use sp_mergepreparecleanup to initiate the first phase of merge meta data cleanup.

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

In this blog post, you’ll learn more about the SQL Server Error Code 11441 and the error message description that is shown SQL Server Error Code 11441 SQL Server Error Description for the Code :11441 The ALTER TABLE SWITCH statement failed because table ‘%.*ls’ and its ordered clustered columnstore index has ordered columns that do not match the ordered columns in table ‘%.*ls’ and its…

SQL Server Error Code – 46710 unsupported transaction manager request

In this blog post, you’ll learn more about the SQL Server Error Code 46710 and the error message description that is shown SQL Server Error Code 46710 SQL Server Error Description for the Code :46710 Unsupported transaction manager request %d encountered. SQL Server Parallel DataWarehousing TDS endpoint only supports local transaction request for ‘begin/commit/rollback’.