Add Method

SQL-DMO

Add Method

The Add method appends the object specified to an appropriate SQL-DMO collection.

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

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.

previous page start next page