• [アーティクル]

RemoteServers Collection

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。

The RemoteServers collection contains RemoteServer objects that expose the attributes of an instance of Microsoft SQL Server visible as a remote server.

現在のオブジェクトを表す SQL-DMO オブジェクト モデル

Properties

Count Property

説明

SQL Server provides several mechanisms to help manage connections between instances of SQL Server in an organization. One mechanism is remote-server naming.

An instance of SQL Server can maintain authentication information for connections originating from other instances of SQL Server. Each instance of SQL Server in an organization can control access by listing instances of SQL Server from which it accepts connections.

Additionally, when a remote server is named at an instance of SQL Server, the server maintaining the name list can, in turn, originate a connection to a named remote server.

注意注

Remote server naming is one method for configuring server-initiated access for instances of SQL Server in an organization. SQL Server version 7.0 implements distributed queries using persisted OLE DB data source definitions called linked servers. For more information, see LinkedServer Object.

With the RemoteServers collection, you can:

  • Identify an instance of SQL Server as a remote server.

  • Remove remote server naming.

  • Rename an instance of SQL Server.

To identify an instance of SQL Server as a remote server

  1. Create a RemoteServer object.

  2. Configure the RemoteServer object by setting the Name, NetName, and Options properties.

  3. Add the RemoteServer object to the RemoteServers collection of a connected SQLServer object.

To remove a named remote server, disabling access to or from the instance

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

    oSQLServer.RemoteServers.Remove("LONDON1")

To rename an instance of SQL Server

  1. Use the Remove method of the RemoteServers collection, providing the existing name of the instance SQL Server in the method call.

  2. Create a RemoteServer object.

  3. Configure the RemoteServer object by setting the Name property to the new name.

  4. Configure the RemoteServer object by setting the NetName property to the network name of the instance of SQL Server.

  5. Add the RemoteServer object to the RemoteServerscollection of the SQLServer object.

  6. Use the Shutdown and Start methods of the SQLServerobject to restart the instance of SQL Server.

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

Set oRemoteServer = oSQLServer.RemoteServers("SEATTLE2")

Or:

Set oRemoteServer = oSQLServer.RemoteServers(2)
注意注

Creating or removing remote server entries by using the RemoteServers collection requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the fixed role setupadmin or a role with greater privilege.