Share via


Unlock Element (XMLA)

Unlocks a specified lock on a Microsoft SQL Server 2005 Analysis Services (SSAS) instance.

Syntax

<Command>
   <Unlock>
      <ID>...</ID>
   </Unlock>
</Command>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

Element Relationships

Relationship Element

Parent elements

Command

Child elements

ID

Remarks

The Unlock command removes a lock established within the context of the currently active transaction. Only database administrators or server administrators can explicitly issue an Unlock command.

All locks are held in the context of the current transaction. When the current transaction is committed or rolled back, all locks defined within the transaction are automatically released.

See Also

Reference

Lock Element (XMLA)

Concepts

Commands (XMLA)

Help and Information

Getting SQL Server 2005 Assistance