Summary
This article showed you some of the intricacies of replication agents supported by SQL Server 2005. I also introduced you to several system stored procedures that can help you automate some mundane tasks related to replication agents.
The overall behavior of replication agents hasn’t changed, but the new version does offer some welcome improvements in agent security as well as agent profile parameters.
Replication works well out of the box, but knowing the inner workings of each agent will help you troubleshoot any problems you might encounter.