SQL Database Management Objects (SQL-DMO)

This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

SQL Server Database Management Objects (SQL-DMO) has been removed from SQL Server 2008 R2 Express and the SQL Server 2008 R2 Feature Pack. SQL-DMO also does not support Database Engine features introduced after SQL Server 2000. We recommend that you modify applications that currently use this feature as soon as possible. If you must support SQL-DMO, install the Backward Compatibility Components from the SQL Server 2008 Feature Pack from the Microsoft Download Center. Do not use SQL-DMO in new development work; use SQL Server Management Objects (SMO) instead. You can obtain the SMO documentation by installing SQL Server 2008 R2 Books Online.

This section contains information about the SQL Server Database Management Objects (SQL-DMO). SQL-DMO is a collection of COM objects that are designed for programming all aspects of managing Microsoft SQL Server.



Developing SQL-DMO Applications

Provides information about programming SQL-DMO. It includes information about installation and registration, language considerations, and a description of the object model.

SQL-DMO Reference

Provides a detailed reference for all the SQL-DMO classes, methods, properties, collections, and constants.


SQL-DMO topics will not be in future releases of SQL Server Books Online.