BeginAlter 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 BeginAlter method marks the start of a unit of change for the object referenced.

Syntax

object
.BeginAlter()

Parts

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

Prototype (C/C++)

HRESULT BeginAlter();

Remarks

Outside of a BeginAlter/DoAlter block, each change to a SQL Distributed Management Objects (SQL-DMO) object property causes a discrete update to the referenced Microsoft SQL Server component. Group multiple changes by calling the BeginAlter method.

All changes made after the BeginAlter method are submitted to SQL Server the next time the DoAlter method is called on the object.

Applies to:

Alert Object

MergePublication Object

AlertSystem Object

MergePullSubscription Object

Category Object

MergeSubscription Object

DistributionArticle Object

MergeSubsetFilter Object

DistributionDatabase Object

Operator Object

DistributionPublication Object

RegisteredSubscriber Object

DistributionPublisher Object

Schedule Object

DistributionSubscription Object

Table Object

Job Object

TargetServerGroup Object

JobSchedule Object

TransArticle Object

JobServer Object

TransPublication Object

JobStep Object

TransPullSubscription Object

MergeArticle Object

TransSubscription Object

MergeDynamicSnapshotJob Object