Rollback (MDStore Interface)
.gif "ms132786.note(de-de,SQL.90).gif") Hinweis: |
|---|
| Dieses Feature wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature nicht zum Entwickeln neuer Anwendungen, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird, zum frühstmöglichen Zeitpunkt ein. |
The Rollback method of the MDStore interface rolls back a transaction on a database. All changes made to the object subsequent to the initiation of the transaction with the BeginTrans method are voided and the object remains in the state it was in at the time of the beginning of the transaction.
Applies To:clsDatabase
Syntax
object.Rollback
Parameter
- object
The database object on which to roll back the transaction.
Hinweise
If the Rollback method is called without first calling the BeginTrans method, an error occurs.
The following code example begins a transaction on the FoodMart 2000 database, processes the Sales and Budget cubes, and rolls back the transaction. Executing the Rollback method for the database restores the Sales and Budget cubes to the state prior to the execution of the BeginTrans method.
Dim dsoServer As New DSO.Server
Dim dsoDB As DSO.MDStore
Dim dsoCube As DSO.MDStore
' Connect to the local Analysis server.
dsoServer.Connect "LocalHost"
' Open the FoodMart 2000 database.
Set dsoDB = dsoServer.MDStores("FoodMart 2000")
' Begin a transaction on the database.
dsoDB.BeginTrans
' Create a reference to the Sales cube.
Set dsoCube = dsoDB.MDStores("Sales")
' Process the cube, refreshing data.
dsoCube.Process processRefreshData
'Create a reference to the Budget cube.
Set dsoCube = dsoDB.MDStores("Budget")
' Process the cube completely.
dsoCube.Process processFull
' Rollback the transaction
dsoDB.Rollback
Siehe auch
Verweis
BeginTrans (MDStore Interface)
CommitTrans (MDStore Interface)
MDStore Interface
UnlockObject (MDStore Interface)