Remove Method (Objects)

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 Remove method drops the referenced database, agent, or replication object from an instance of Microsoft SQL Server connected to, and removes the SQL Distributed Management Objects (SQL-DMO) object from its containing collection.

Syntax

object
.Remove(
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

Prototype (C/C++)

HRESULT Remove();

Remarks

For more information about using the Remove method of a SQL-DMO object, including information on privilege required, see documentation for the object or its containing collection.

Note

If an application calls Remove 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:

Alert Object

Login Object

BackupDevice Object

MergeArticle Object

Category Object

MergeDynamicSnapshotJob Object

Check Object

MergePublication Object

Column Object

MergePullSubscription Object

Database Object

MergeSubscription Object

DatabaseRole Object

MergeSubsetFilter Object

DBFile Object

RegisteredServer Object

DBObject Object

RegisteredSubscriber Object

Default Object

RemoteLogin Object

DistributionArticle Object

RemoteServer Object

DistributionDatabase Object

Rule Object

DistributionPublication Object

ServerGroup Object

DistributionPublisher Object

StoredProcedure Object

DistributionSubscription Object

Table Object

DRIDefault Object

TargetServerGroup Object

FileGroup Object

TransArticle Object

FullTextCatalog Object

TransPublication Object

Index Object

TransPullSubscription Object

Job Object

TransSubscription Object

JobSchedule Object

Trigger Object

JobStep Object

User Object

Key Object

UserDefinedDatatype Object

LinkedServer Object

UserDefinedFunction Object

LinkedServerLogin Object

View Object