The Explore sample guides a user through the SQL-DMO object tree, displaying the contents of collections and the properties of objects. The sample illustrates using the Properties collection and handling SQLServer object events.
The Explore sample contains a single form, shown in the illustration. The form solicits login information from the user.
Upon successful connection to an indicated server running Microsoft® SQL Server™, SQLServer object properties and their values are displayed in the box at the bottom of the form. The first combo box is enabled, containing SQL-DMO objects and collections dependent upon the SQLServer object. User selection in the combo boxes and lists navigates the user through the configuration of the indicated server.
The Explore sample makes heavy use of the automated properties collection available to automation controllers in iterating property names and their values.