SQL Server Enterprise Manager includes several wizards and dialog boxes you can use to simplify installation and maintenance of replication. SQL Server Enterprise Manager enables you to view and modify the properties of replication, and provides a graphical navigational tool, Replication Monitor, to monitor and troubleshoot replication activity.
Microsoft® SQL Server™ also allows you to install and maintain replication using Transact-SQL stored procedures and programming components such as SQL-DMO.
Replication Wizards | Replication and System Stored Procedures |
Replication and SQL Server Enterprise Manager | Replication Programming Interfaces |