sp_dropmergefilter (Transact-SQL)
Drops a merge filter. sp_dropmergefilter drops all the merge filter columns defined on the merge filter that is to be dropped. This stored procedure is executed at the Publisher on the publication database.
Transact-SQL Syntax Conventions
Składnia
sp_dropmergefilter [ @publication= ] 'publication', [ @article= ] 'article' , [ @filtername= ] 'filtername'
[ , [ @force_invalidate_snapshot= ] force_invalidate_snapshot ]
[ , [ @force_reinit_subscription = ] force_reinit_subscription ]
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 no default.[ @filtername=] 'filtername'
Is the name of the filter to be dropped. filtername is sysname, with no default.[ @force_invalidate_snapshot= ] force_invalidate_snapshot
Enables or disables the ability to have a snapshot invalidated. force_invalidate_snapshot is a bit, with a default 0.0 specifies that changes to the merge article do not cause the snapshot to be invalid.
1 means that changes to the merge article may cause the snapshot to be invalid. If that is the case, a value of 1 gives permission for the new snapshot to occur.
[ @force_reinit_subscription= ] force_reinit_subscription
Enables or disables the ability to mark a subscription as not valid. force_reinit_subscription is a bit, with a default 0.0 specifies that changes to the merge article filter do not cause the subscriptions to be invalid.
1 means that changes to the merge article filter causes the subscriptions to be invalid.
Return Code Values
0 (success) or 1 (failure)
Uwagi
sp_dropmergefilter is used in merge replication.
Permissions
Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_dropmergefilter.
Zobacz także
Odwołanie
sp_addmergefilter (Transact-SQL)
sp_changemergefilter (Transact-SQL)
sp_helpmergefilter (Transact-SQL)
System Stored Procedures (Transact-SQL)