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

A SQL Distributed Management Objects (SQL-DMO) object exposes the attributes of a Microsoft SQL Server component.


All SQL-DMO objects expose properties. For a specific instance of an object, the properties identify a specific SQL Server component. For example, the SystemDatatype object with a Name value varchar has properties that define the SQL Server data type varchar.

Some objects expose methods that act on a component as directed by the application. For example, the Script method of a StoredProcedure object creates a Transact-SQL script that can re-create the referenced SQL Server stored procedure.

Some objects support events. Events communicate from the SQL-DMO object to the application. For example, the PercentComplete event of a Backup object provides notification that the backup operation specified has reached an application-defined point.