SQL Server Error Code – 22856 warning: the @allow_partition_switch par

In this blog post, you’ll learn more about the SQL Server Error Code 22856 and the error message description that is shown

SQL Server Error Code

22856

SQL Server Error Description for the Code :22856

Warning: The @allow_partition_switch parameter is set to 0. ALTER TABLE … SWITCH PARTITION statement will be disallowed on this partitioned table. Refer to books online for more information about partition switching behavior when using Change Data Capture.

Leave Your Comment