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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
