Редактиране

Споделяне чрез

sp_check_dynamic_filters (Transact-SQL)

  • Статия

Applies to: SQL Server Azure SQL Managed Instance

Displays information on parameterized row filter properties for a publication, in particular the functions used to generate a filtered data partition for a publication and whether the publication qualifies for using precomputed partitions. This stored procedure is executed at the Publisher on the publication database.

Transact-SQL syntax conventions

Syntax

sp_check_dynamic_filters [ @publication = ] N'publication'
[ ; ]

Arguments

[ @publication = ] N'publication'

The name of the publication. @publication is sysname, with no default.

Result set

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 can't be used.
has_dynamic_filters bit Is if at least one parameterized row filter is defined in the publication; where 1 means that one or more parameterized row filters exist, and 0 means that no dynamic filters exist.
dynamic_filters_function_list nvarchar(500) List of functions used to filter articles in a publication, where each function is separated by a semi-colon.
validate_subscriber_info nvarchar(500) List of functions used to filter articles in a publication, where each function is separated by a plus sign (+).
uses_host_name bit If the HOST_NAME function is used in parameterized row filters, where 1 means that this function is used for dynamic filtering.
uses_suser_sname bit If the SUSER_SNAME function is used in parameterized row filters, where 1 means that this function is used for dynamic filtering.

Return code values

0 (success) or 1 (failure).

Remarks

sp_check_dynamic_filters is used in merge replication.

If a publication is defined to use precomputed partitions, sp_check_dynamic_filters checks for any violations of the restrictions of precomputed partitions. If any are found, an error is returned. For more information, see Parameterized Filters - Optimize for Precomputed Partitions.

If a publication is defined with parameterized row filters, but no parameterized row filters are found, an error is returned.

Permissions

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_check_dynamic_filters.

Related content