共用方式為

ReplicationDatabases Collection

  • 發行項

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。

The ReplicationDatabases collection contains ReplicationDatabase objects that enumerate the user-defined databases.

顯示目前物件的 SQL-DMO 物件模型

Properties

Count Property

Methods

Item Method

Refresh Method

ItemByID Method

Script Method (Replication Objects)

備註

Microsoft SQL Server replication publications derive article data from only user-defined databases. To simplify replication configuration when using SQL Distributed Management Objects (SQL-DMO), SQL-DMO implements the ReplicationDatabases collection, which lists user-defined databases.

With the ReplicationDatabases collection, you can:

  • Enumerate user-defined databases on an instance of SQL Server.
  • Generate a Transact-SQL script to automate creation or other administration of all user-defined databases.

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

Set oReplicationDatabase = _
oSQLServer.Replication.oReplicationDatabases("Northwind")

Or:

Set oReplicationDatabase = _
oSQLServer.Replication.oReplicationDatabases(1)