다음을 통해 공유

  • 아티클

SQLServers Collection

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

The SQLServers collection contains SQLServer objects created by the SQL Distributed Management Objects (SQL-DMO) application.

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

Properties

Count Property

 

주의

SQL-DMO maintains the SQLServers collection. Members are added when the application creates a new instance of a SQLServer object and are removed when the application releases all references it holds on the member. For example:

Dim     oSQLServer as SQLDMO.SQLServer
' SQLServer object not created. No member in SQLServers collection.

Set oSQLServer = New SQLDMO.SQLServer
' SQLServer object is now a member of the SQLServers collection.

Set oSQLServer = Nothing 
' SQLServer object references released and member removed
' from SQLServers collection.

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

Set oSQLServer = oApplication.SQLServers("SEATTLE1")

Or:

Set oSQLServer = oApplication.SQLServers(2)