DoAlter Method

Article
12/03/2008

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 DoAlter method marks the end of a unit of change for the object referenced and submits changes made to property values.

Syntax

object
.DoAlter( )

Parts

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

Prototype (C/C++)

HRESULT DoAlter( );

Remarks

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

All SQL-DMO property changes made after the BeginAlter method are submitted to SQL Server the next time DoAlter is called on the object. Changes are discarded if the CancelAlter method is called.

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