Replication Stored Procedures

Replication system stored procedures are documented and available as a method for implementing replication in special circumstances or for use in batch files and scripts. However, in most cases, you are better served by using the programming interfaces provided by SQL-DMO and the replication ActiveX® controls for programming replication rather than writing direct calls to the system stored procedures.

An advantage to using scripts based on system stored procedures is that you can implement replication, create publications and subscriptions on a server, generate the script automatically through SQL Server Enterprise Manager, and then use that script at other servers to implement replication components, often with only minor modifications. Executing a script can be faster and more efficient than performing the same steps repeatedly using SQL Server Enterprise Manager.

For more information, see Scripting Replication.