This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
SQL Distributed Management Objects (SQL-DMO) collections are containers for objects of identical type. That is, the TypeOf property returns the same value for any object contained in a given collection. For example, the Tables collection contains only SQL-DMO Table objects.
All SQL-DMO collections expose the Application, Count, Parent, TypeOf, and UserData properties, and support the Item method. The Item method selects a contained object from the collection, using a supplied ordinal or name string to identify the desired collection member. For information about Item method variations, see each collection.