Using the Properties Collection

The Property object and the Properties collection are only available in Visual Basic.

Visual Basic

Each SQL-DMO object (not including collections) has a Properties collection that contains one Property object for each property (not including object properties or indexed properties) of the SQL-DMO object.

Using the Properties collection and the following properties of the Property object you can:

• Enumerate the property names of a SQL-DMO object at run time using the Name property.
• Get and set the value of a property name determined at run time using the Value property.

For example:

For Each oProperty in oSQLServer.Properties
    Debug.Print oProperty.Name & " = " oProperty.Value
Next

The default property of a Property object is the Value property.

C++

The Property object and the Properties collection are not available in C++.