Description of the SQLServer Object

The SQLServer object is the core of 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.