How to replace statements with custom stored procedures (Enterprise Manager)

To use the Transact-SQL replication mechanism for a statement type

1. Expand a server group; then expand the Publisher.
2. On the Tools menu, point to Replication, and then click Create and Manage Publications.
3. Expand the database containing the publication to modify.
4. Click the publication; then click Properties & Subscriptions.
5. Click the Articles tab.
6. Clear Replace statement statements with this stored procedure.

To specify no processing for a statement type

1. Expand a server group; then expand the Publisher.
2. On the Tools menu, point to Replication, and then click Create and Manage Publications.
3. Expand the database containing the publication to modify.
4. Click the publication; then click Properties & Subscriptions.
5. Click the Articles tab.
6. Select Replace statement statements with this stored procedure.
7. Enter NONE.

To specify custom processing for a statement type

1. Expand a server group; then expand the Publisher.
2. On the Tools menu, point to Replication, and then click Create and Manage Publications.
3. Expand the database containing the publication to modify.
4. Click the publication; then click Properties & Subscriptions.
5. Click the Articles tab.
6. Select Replace statement statements with this stored procedure.
7. Enter the name of the stored procedure to replace the statement type. The stored procedure must be created in each Subscriber’s destination database.