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.

See Also