Unlock Element (XMLA)


Applies To: SQL Server 2016 Preview

Unlocks a specified lock on a Microsoft SQL Server Analysis Services instance.


Data type and lengthNone
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
Parent elementsCommand
Child elementsID

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.

Lock Element (XMLA)
Commands (XMLA)

Community Additions