RegisteredServers Collection (SQL-DMO)

The RegisteredServers collection contains RegisteredServer objects exposing the attributes of a single registry-listed Microsoft® SQL Server™ installation.

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.

With the RegisteredServers collection, you can:

• Create a Windows NT or Windows 95 registry entry that lists a SQL Server installation by SQL Server name.
• Remove a Windows NT or Windows 95 registry entry listing a SQL Server installation.

For more information about creating registry entries organizing SQL Server installations, see RegisteredServer Object.

To remove a registry entry listing a SQL Server installation

• Use the Remove method of the RegisteredServers collection, as in:

    oApplication.RegisteredServers.Remove("SEATTLE1")

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

Set oRegisteredServer = oApplication.RegisteredServers("LONDON2")

Or:

Set oRegisteredServer = oApplication.RegisteredServers(2)

Methods

Properties

Count Property