Category: SQL Server

SQL Server Error Code – 10723 in a merge statement, a variable cannot

In this blog post, you’ll learn more about the SQL Server Error Code 10723 and the error message description that is shown SQL Server Error Code 10723 SQL Server Error Description for the Code :10723 In a MERGE statement, a variable cannot be set to a column and expression in the same assignment in the SET clause of an UPDATE action. Assignments of the form…

SQL Server Error Code – 8657 could not get the memory grant of %i64d

In this blog post, you’ll learn more about the SQL Server Error Code 8657 and the error message description that is shown SQL Server Error Code 8657 SQL Server Error Description for the Code :8657 Could not get the memory grant of %I64d KB because it exceeds the maximum configuration limit in workload group ‘%ls’ (%ld) and resource pool ‘%ls’ (%ld).  Contact the server administrator…

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

In this blog post, you’ll learn more about the SQL Server Error Code 4953 and the error message description that is shown SQL Server Error Code 4953 SQL Server Error Description for the Code :4953 ALTER TABLE SWITCH statement failed. The columns set used to partition the table ‘%.*ls’ is different from the column set used to partition the table ‘%.*ls’.