SQL-DMO API

SQL Distributed Management Objects (SQL-DMO) encapsulate the objects found in Microsoft® SQL Server™ databases. SQL-DMO allows applications written in languages that support OLE Automation or COM to administer all parts of a SQL Server installation. SQL-DMO is the API used by the SQL Server version 7.0 SQL Server Enterprise Manager, so applications using SQL-DMO can perform all functions performed by SQL Server Enterprise Manager.

SQL-DMO is intended for any OLE Automation or COM application that needs to incorporate SQL Server administration. Examples include:

• Applications that encapsulate SQL Server as their data store and want to shield users from as much SQL Server administration as possible.
• Applications that have specialized administrative logic incorporated the application itself.
• Applications that want to integrate SQL Server administrative tasks in their own user interface.

See Also