sys.sp_check_subset_filter

Description

Checks a filter clause against any table to determine if the filter clause is valid for the table. This stored procedure returns information about the supplied filter, including if the filter qualifies for use with precomputed partitions. This stored procedure is executed at the Publisher on the database containing the publication. The filter clause being tested. Specifies whether the filter clause is a parameterized row filter.

Syntax

sp_check_subset_filter
[ @filtered_table = ]
N
'filtered_table'
, [ @subset_filterclause = ]
N
'subset_filterclause'
[ , [ @has_dynamic_filters = ] has_dynamic_filters
OUTPUT
]
[ , [ @dynamic_filters_function_list = ]
N
'dynamic_filters_function_list'
OUTPUT
]
[ ; ]

Permissions

Only members of the fixed server role or fixed database role can execute. Parameterized Filters - Optimize for Precomputed Partitions