0 out of 5 rated this helpful - Rate this topic

Unlock Element (XMLA)

SQL Server 2005

SQL Server 2012

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


<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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Unlock Element (XMLA)

Reference

Concepts

Help and Information

Community Additions