共用方式為


Add Method

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

The Add method appends the object specified to an appropriate SQL Distributed Management Objects (SQL-DMO) collection.

語法

object
.Add(
ObjectToAdd
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • ObjectToAdd
    Expression that evaluates to an object of the type contained in the collection.

Prototype (C/C++)

HRESULT Add(LPSQLDMOobject pObject);

備註

For any collection exposing the Add method, the method implements Microsoft SQL Server component creation. Component creation can occur as the SQL-DMO object is added to its containing collection, or at some other application-directed time.

For more information about component creation by using the Add method of the SQL-DMO collection, see documentation for SQL-DMO objects and collections.

ms141810.note(zh-tw,SQL.90).gif附註:
If an application calls Add with the MergeArticles object after the initial snapshot has been created, a new snapshot must be generated and reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and merge agent run. If an application calls Add with the TransPublication object after the initial snapshot has been created, a new snapshot must be generated. Snapshots are applied when the next scheduled snapshot agent runs.

Applies to:

AlertCategories Collection

MergeDynamicSnapshotJobs Collection

Alerts Collection

MergePublications Collection

BackupDevices Collection

MergePullSubscriptions Collection

Checks Collection

MergeSubscriptions Collection

Columns Collection

MergeSubsetFilters Collection

DatabaseRoles Collection

Names Collection

Databases Collection

OperatorCategories Collection

DBFiles Collection

Operators Collection

Defaults Collection

RegisteredServers Collection

DistributionArticles Collection

RegisteredSubscribers Collection

DistributionDatabases Collection

RemoteLogins Collection

DistributionPublications Collection

RemoteServers Collection

DistributionPublishers Collection

Rules Collection

DistributionSubscriptions Collection

ServerGroups Collection

FileGroups Collection

StoredProcedures Collection

FullTextCatalogs Collection

Tables Collection

Indexes Collection

TargetServerGroups Collection

JobCategories Collection

TransArticles Collection

Jobs Collection

TransPublications Collection

JobSchedules Collection

TransPullSubscriptions Collection

JobSteps Collection

TransSubscriptions Collection

Keys Collection

Triggers Collection

LinkedServerLogins Collection

UserDefinedDatatypes Collection

LinkedServers Collection

UserDefinedFunctions Collection

LogFiles Collection

Users Collection

Logins Collection

Views Collection

MergeArticles Collection