TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_helpmergefilter (Transact-SQL)

 

Applies To: SQL Server

Returns information about merge filters. This stored procedure is executed at the Publisher on any database.

Topic link icon Transact-SQL Syntax Conventions


sp_helpmergefilter [ @publication= ] 'publication' 
    [ , [ @article= ] 'article']
    [ , [ @filtername= ] 'filtername']

[ @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.

Column nameData typeDescription
join_filteridintID of the join filter.
filternamesysnameName of the filter.
join article namesysnameName of the join article.
join_filterclausenvarchar(2000)Filter clause qualifying the join.
join_unique_keyintWhether the join is on a unique key.
base table ownersysnameName of the owner of the base table.
base table namesysnameName of the base table.
join table ownersysnameName of the owner of the table being joined to the base table.
join table namesysnameName of the table being joined to the base table.
article namesysnameName of the table article being joined to the base table.
filter_typetinyintType of merge filter, which can be one of the following:

 1 = join filter only

 2 = logical record relationship

 3 = both

0 (success) or 1 (failure)

sp_helpmergefilter is used in merge replication.

Only members of the sysadmin fixed server role and the db_owner fixed database role can execute sp_helpmergefilter.

sp_addmergefilter (Transact-SQL)
sp_changemergefilter (Transact-SQL)
sp_dropmergefilter (Transact-SQL)
System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft