Developing SQL-DMO Applications SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating Microsoft® SQL Server™ database and replication management.
SQL-DMO is a dual interface COM, in-process server implemented as a dynamic-link library (DLL). When creating a SQL-DMO application, you can use any OLE Automation controller or COM client development platform using C or C++.
SQL-DMO automates:
Repetitive or commonly performed SQL Server administrative tasks.
SQL Server object creation and administration.
Creation and administration of SQL Server Agent jobs, alerts, and operators.
SQL Server replication installation and configuration. SQL-DMO documentation covers the components of SQL-DMO, their use in developing applications, and SQL-DMO application construction. It also includes a detailed component reference.
