Properties (SQL-DMO)

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.

The values of SQL Distributed Management Objects (SQL-DMO) properties identify a specific Microsoft SQL Server component. Some properties can be set, allowing configuration of a SQL Server component. Others are read-only, providing information about a specific component.

All SQL-DMO objects expose the Parent, TypeOf, and UserData properties. Other properties may be shared by objects, but many properties are specific to a component, clearly associating the property with a specific task or configured value of the component.