Add Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

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

Remarks

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.

Note

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