Custom Stored Procedures

Why use stored procedures during replication? Let's start with the obvious: Use stored procedures to improve the performance of the replication process. Stored procedures improve performance by using precompiled SQL statements during replication. Stored procedures also reduce network traffic because you pass only the stored procedure name and parameters rather than the entire SQL statement. You can also use stored procedures to perform custom processing on the subscribing server such as reformatting the data to simplify end-user queries. The custom stored procedures might be as simple as translating an integer status field to a character field that reports SUCCESS or ERROR.

You have the option of using custom stored ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.