You must create a function replication definition before you can subscribe to it. Typically, you create the function replication definition for a stored procedure under its primary database, and subscribe to the function replication definition under its replicate database.
The Add New Subscription dialog box enables you to create a new subscription for the selected stored procedures, displaying several tabs:
General – view and edit general information about the subscription.
Where Clause – create a qualifier for the subscription; for example, create a SQL statement to limit the subscription to a specific range of records.
Adding a subscription
In the left pane, navigate to Stored Procedures under the replicate database, select the stored procedure you want, and expand its directory.
In the right pane, double-click Add Subscription.
Complete the General and Where Clause tabs.
Click OK. The subscription displays in the right pane.
