Description of the SQLServer Object

The SQLServer object is the heart of SQL-DMO. It is through the SQLServer object that an application connects to and alters the properties of organization servers running Microsoft® SQL Server™.

Many SQL-DMO objects are exposed as properties of other SQL-DMO objects. Any SQL-DMO object referencing an existing SQL Server component can be selected by navigating from the SQLServer object. This implementation detail creates a tree, structuring 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 a SQL Server installation.
• 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.