Compartilhar via

  • Artigo

SQLServers Collection

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

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

Modelo de objeto do SQL-DMO mostrando o objeto atual

Properties

Count Property

 

Comentários

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)