RegisteredServers Collection

SQL-DMO

SQL-DMO

RegisteredServers Collection

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

Properties
Count Property
Methods
Add Method Refresh Method
Item Method Remove Method (Collections)

Remarks

SQL-DMO applications can maintain lists of some or all of instances of SQL Server 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 an instance of SQL Server by SQL Server name.

  • Remove a Windows NT or Windows 95 registry entry listing an instance of SQL Server.

For more information about creating registry entries that organize instances of SQL Server, see the RegisteredServer Object section.

To remove a registry entry that lists an instance of SQL Server

  • 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)