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

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

SQL Server Error Code

22857

SQL Server Error Description for the Code :22857

Warning: The @allow_partition_switch parameter must be 1 for tables that are not partitioned. The explicit setting of the parameter to 0 was ignored. Refer to books online for more information about partition switching behavior when using Change Data Capture.

Leave Your Comment