다음을 통해 공유

ServerGroups Collection

  • 아티클

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The ServerGroups collection contains ServerGroup objects that expose a classification system for the registry-maintained list of instances of Microsoft SQL Server.

현재 개체를 보여 주는 SQL-DMO 개체 모델

Properties

Count Property

 

Methods

Add Method

Refresh Method

Item Method

Remove Method (Collections)

주의

SQL Distributed Management Objects (SQL-DMO) applications can maintain lists of some or all instances of SQL Server in an organization. The lists are stored in the Windows registry.

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 instances of SQL Server.

With the ServerGroups collection, you can:

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

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

  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 instances maintained under the classification.

  3. Use the Remove method of the ServerGroup object to remove the classification.

    ms141092.note(ko-kr,SQL.90).gif중요:
    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)