.png)
sp_check_subset_filter (Transact-SQL)
Is used to check 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.
Column name | Data type | Description |
|---|---|---|
can_use_partition_groups | bit | Is if the publication qualifies for using precomputed partitions; where 1 means that precomputed partitions can be used, and 0 means that they cannot be used. |
has_dynamic_filters | bit | Is if the supplied filter clause includes at least one parameterized row filter; where 1 means that a parameterized row filter is used, and 0 means that such a function is not used. |
dynamic_filters_function_list | nvarchar(500) | List of the functions in the filter clause that dynamically filter an article, where each function is separated by a semi-colon. |
uses_host_name | bit | If the HOST_NAME() function is used in the filter clause, where 1 means that this function is present. |
uses_suser_sname | bit | If the SUSER_SNAME() function is used in the filter clause, where 1 means that this function is present. |
