Description of the SQLServer Object

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.

The SQLServer object is the core of SQL Distributed Management Objects (SQL-DMO). It is through the SQLServer object that an application connects to and alters the properties of instances of Microsoft SQL Server.

Many SQL-DMO objects are exposed as properties of other SQL-DMO objects. Any SQL-DMO object that references an existing SQL Server component can be selected by navigating from the SQLServer object. This implementation detail creates a tree that structures SQL-DMO objects logically to guide and ease development.

Regardless of the development tool used to create an application, all SQL-DMO applications share basic logical elements. A SQL-DMO application will:

  • Create a SQLServer object.

  • Use the Connect method of the SQLServer object to establish a session with an instance of SQL Server.

  • Use the SQL-DMO object selection methods of the SQLServer object to choose specific objects for modification.

These topics introduce the SQLServer object and describe the relationship of objects in SQL-DMO.

Community Additions