In this blog post, let’s learn about the error message “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 ALTER TABLE SWITCH.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
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 ALTER TABLE SWITCH.
Reason for the Error
To be update soon…
Solution
To be update soon…