sys.sp_generatefilters

Description

Creates filters on foreign key tables when a specified table is replicated. This stored procedure is executed at the Publisher on the publication database.

Syntax

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

Permissions

06/23/2025 This stored procedure is executed at the Publisher on the publication database. syntaxsql The name of the publication to be filtered. @publication is , with no default. (success) or (failure). is used in merge replication. Only members of the fixed server role or the fixed database role can execute.