sp_helpmergefilter
Returns information about merge filter(s). This stored procedure is executed at the Publisher on the publication database.
Syntax
sp_helpmergefilter [ @publication = ] 'publication'
[ , [ @article = ] 'article']
[ , [ @filtername = ] 'filtername']
Arguments
[@publication = ] 'publication'
Is the name of the publication. publication is sysname, with no default.
[@article = ] 'article'
Is the name of the article. article is sysname, with a default of %, which returns the names of all articles.
[@filtername = ] 'filtername'
Is the name of the filter about which to return information. filtername is sysname, with a default of %, which returns information about all the filters defined on the article or publication.
Result Sets
| Column name | Data type | Description |
|---|---|---|
| join_filterid | int | ID of the join filter. |
| filtername | sysname | Name of the filter. |
| join article name | sysname | Name of the join article. |
| join_filterclause | nvarchar(2000) | Filter clause qualifying the join. |
| join_unique_key | int | Whether the join is on a unique key. |
| base table owner | sysname | Name of the owner of the base table. |
| base table name | sysname | Name of the base table. |
| join table owner | sysname | Name of the owner of the table being joined to the base table. |
| join table name | sysname | Name of the table being joined to the base table. |
| article name | sysname | Name of the article. |
Remarks
sp_helpmergefilter is used in merge replication.
Permissions
Execute permissions default to the public role.