SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Analysis Services - Multidimensional Data
Technical Reference
XML for Analysis Reference
XML Elements (XMLA)
Properties (XMLA)
AllowOverwrite Element (XMLA)
ApplyCompression Element (XMLA)
Attribute Element (XMLA)
AttributeName Element (XMLA)
Attributes Element (XMLA)
Axes Element (XMLA)
AxesInfo Element (XMLA)
Axis Element (XMLA)
AxisInfo Element (XMLA)
BackupRemotePartitions Element (XMLA)
Binding Element (XMLA)
Bindings Element (XMLA)
CancelAssociated Element (XMLA)
Capability Element (XMLA)
Caption Element (XMLA)
Cell Element (XMLA)
Cell Element (MDDataSet) (XMLA)
CellData Element (XMLA)
CellInfo Element (XMLA)
CellOrdinal Element (XMLA)
Command Element (XMLA)
ConnectionID Element (XMLA)
ConnectionString Element (XMLA)
CrossProduct Element (XMLA)
Cube Element (XMLA)
Cube Element (OlapInfo) (XMLA)
CubeID Element (XMLA)
CubeInfo Element (XMLA)
CubeName Element (XMLA)
CustomRollup Element (XMLA)
CustomRollupProperties Element (XMLA)
Database Element (XMLA)
DatabaseID Element (XMLA)
DatabaseName Element (XMLA)
DataSource Element (XMLA)
DataSourceID Element (XMLA)
DataSourceType Element (XMLA)
DataSourceView Element (XMLA)
DbSchemaName Element (XMLA)
DbStorageLocation Element
DbTableName Element (XMLA)
DeleteWithDescendants Element (XMLA)
Description Element (XMLA)
Dimension Element (XMLA)
DisplayInfo Element (XMLA)
Error Element (XMLA)
ErrorCode Element (XMLA)
ErrorConfiguration Element (XMLA)
Exception Element (XMLA)
File Element (XMLA)
Folder Element (XMLA)
Folders Element (XMLA)
HelpFile Element (XMLA)
HierarchyInfo Element (XMLA)
ID Element (XMLA)
Keys Element (XMLA)
Key Element (XMLA)
Key Element (SetEncryptionKey) (XMLA)
Language Element (XMLA)
LastDataUpdate Element (XMLA)
LastSchemaUpdate Element (XMLA)
LName Element (XMLA)
LNum Element (XMLA)
Location Element (XMLA)
Locations Element (XMLA)
Materialize Element (XMLA)
MeasureGroupID Element (XMLA)
Member Element (XMLA)
Members Element (XMLA)
Message Element (XMLA)
Messages Element (XMLA)
Mode Element (XMLA)
MoveWithDescendants Element (XMLA)
Name Element (XMLA)
Name Element (Parameter) (XMLA)
New Element (XMLA)
Object Element (XMLA)
Object Element (Dimension) (XMLA)
ObjectDefinition Element (XMLA)
OlapInfo Element (XMLA)
Optimization Element (XMLA)
Original Element (XMLA)
Parallel Element (XMLA)
Parameter Element (XMLA)
Parameters Element (XMLA)
ParentObject Element (XMLA)
PartitionID Element (XMLA)
Password Element (XMLA)
Properties Element (XMLA)
PropertyList Element (XMLA)
Queries Element (XMLA)
Query Element (XMLA)
ReadWriteMode Element
RequestType Element (XMLA)
RestrictionList Element (XMLA)
Restrictions Element (XMLA)
results Element (XMLA)
return Element (XMLA)
root Element (XMLA)
row Element (XMLA)
Security Element (XMLA)
SessionID Element (XMLA)
SkippedLevels Element (XMLA)
Source Element (XMLA)
Source Element (Error) (XMLA)
Source Element (Synchronize) (XMLA)
Sources Element (XMLA)
SPID Element (XMLA)
Steps Element (XMLA)
Storage Element (XMLA)
SynchronizeSecurity Element (XMLA)
TableNotification Element (XMLA)
TableNotifications Element (XMLA)
Target Element (XMLA)
Time Element (XMLA)
Translation Element (XMLA)
Translations Element (XMLA)
Tuple Element (XMLA)
Tuples Element (XMLA)
Type Element (XMLA)
UName Element (XMLA)
UnaryOperator Element (XMLA)
Value Element (XMLA)
Value Element (Parameter) (XMLA)
Warning Element (XMLA)
Where Element (XMLA)
WritebackTableCreation Element (XMLA)
Expand Minimize
This topic has not yet been rated - Rate this topic

ReadWriteMode Element

SQL Server 2008 R2

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.

Xml
Copy 

<Database>
...
   <ddlns_100_0:ReadWriteMode>...</ddlns_100_0:ReadWriteMode>
...
</Database>

Characteristic

Description

Data type and length

String (enumeration)

Default value

ReadWrite

Cardinality

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

Relationship

Element

Parent elements

Database

Child elements

None

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.

Value

Description

ReadOnly

No changes or updates can be applied to the database.

ReadWrite

Changes and updates can be applied to the database.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.