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.

附註：

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