UnlockObject (Dimension Interface)

注意：
下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能，并尽快修改当前还在使用该功能的应用程序。

The UnlockObject method of the Dimensioninterface releases a lock on a dimension object previously established by the LockObject method.

Applies To:clsDatabaseDimension

语法

object.UnlockObject    

备注

• object
  The Dimension object to unlock.

备注

Calling the UnlockObject method without first calling the LockObject method raises an error.

示例

The following example locks the Product dimension of the FoodMart 2000 database, completely reprocesses it, and then unlocks it so others make changes:

    Dim dsoServer As New DSO.Server
    Dim dsoDB As DSO.MDStore
    Dim dsoDim As DSO.Dimension
    
    ' Connect to local Analysis server.
    dsoServer.Connect "LocalHost"
    
    ' Open FoodMart 2000 database.
    Set dsoDB = dsoServer.MDStores("FoodMart 2000")

    ' Open the Product dimension.
    Set dsoDim = dsoDB.Dimensions("Product")
    
    ' Lock the dimension for processing.
    dsoDim.LockObject olapLockProcess, "Locked for processing."
    
    ' Completely reprocess the dimension.
    dsoDim.Process processFull
    
    ' Once complete, unlock the dimension.
    dsoDim.UnlockObject
    
    ' Clean up.
    Set dsoDim = Nothing
    Set dsoDB = Nothing
    dsoServer.CloseServer
    Set dsoServer = Nothing

请参阅

参考

Dimension Interface
LockObject (Dimension Interface)

帮助和信息

获取 SQL Server 2005 帮助