ReadWriteMode Element


Applies To: SQL Server 2016 Preview

The ReadWriteMode database property specifies whether the database is in ReadWrite mode or in ReadOnly mode. These are the only two possible values of the property.


Data type and lengthString (enumeration)
Default valueReadWrite
Cardinality0-1: Optional element that can occur more than once.
Parent elementsDatabase
Child elementsNone

Databases are created in ReadWrite mode only. Databases cannot be created in ReadOnly mode.

The value of the ReadWriteMode element is limited to one of the strings listed in the following table.

ReadOnlyNo changes or updates can be applied to the database.
ReadWriteChanges and updates can be applied to the database.

Attach Element
Attach and Detach Analysis Services Databases
Move an Analysis Services Database
Database ReadWriteModes
Switch an Analysis Services database between ReadOnly and ReadWrite modes

Community Additions