DoAlter Method (SQL-DMO)

The DoAlter method marks the end of a unit of change for the object referenced and submits changes made to property values.

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

Syntax

object.DoAlter()

Part Description
object Expression that evaluates to an object in the Applies To list

Remarks

Outside of a BeginAlter/DoAlter block, each change to a 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.

Prototype (C/C++)

HRESULT DoAlter();

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.