ServerGroups Collection (SQL-DMO)

The ServerGroups collection contains ServerGroup objects exposing a classification system for the registry-maintained list of Microsoft® SQL Server™ installations.

Remarks

SQL-DMO applications can maintain lists of some or all of the SQL Server installations in an organization. The lists are stored in the registry of a Microsoft Windows NT® or Microsoft Windows® 95/98 system.

Each registry-maintained list is visible in a SQL-DMO application through the RegisteredServers collection. A ServerGroup object classifies a list, providing a meaningful name for a list of SQL Server installations.

With the ServerGroups collection, you can:

• Create a category used to classify a registry-maintained list of SQL Server installations.
• Remove a category classifying registry-maintained lists of SQL Server installations.

To create a classification for registry-maintained lists of SQL Server installations

1. Create a ServerGroup object.
2. Set the Name property of the ServerGroup object.
3. Add the ServerGroup object to the ServerGroups collection of the Application object.

To remove an organization server classification

1. Get the ServerGroup object referencing the target classification from the ServerGroups collection of the Application object.
2. Use the Remove method of the RegisteredServers collection of the target ServerGroup object to remove any installations maintained under the classification.
3. Use the Remove method of the ServerGroup object to remove the classification.

Important When using the ServerGroups collection to remove an existing registry-maintained classification, the RegisteredServers collection of the target ServerGroup object must be empty.

When using the Item or Remove method, the ServerGroups collection supports member identification using either name or ordinal reference syntax. For example:

Set oServerGroup = oApplication.ServerGroups("London")

Or:

Set oServerGroup = oApplication.ServerGroups(1)

Methods

Properties

Count Property