sys.sp_addmergepartition

Description

Creates a dynamically filtered partition for a subscription, filtered by the values of at the Subscriber. This stored procedure is executed at the Publisher on the database that is being published, and is used to manually generate partitions. The merge publication on which the partition is being created.

Syntax

sp_addmergepartition
[ @publication = ]
N
'publication'
[ , [ @suser_sname = ]
N
'suser_sname'
]
[ , [ @host_name = ]
N
'host_name'
]
[ ; ]

Permissions

Only members of the fixed server role or fixed database role can execute. Create a Snapshot for a Merge Publication with Parameterized Filters Parameterized Filters - Parameterized Row Filters