Specifying the Maximum Number of Rows in the Violations Table (XPS)

The following statement starts a violations table for the target table named orders. The MAX VIOLATIONS clause specifies the maximum number of rows that any single coserver can insert into the violations table when a single statement, such as an INSERT statement, is executed on the target table.

START VIOLATIONS TABLE FOR orders MAX VIOLATIONS 50000