This topic has not yet been rated - Rate this topic

Attach Element

SQL Server 2008

Attaches a Microsoft SQL Server Analysis Services database that was previously detached from the current server instance or from another instance, to the current server instance.

Syntax

Xml


<Command>
   <Attach>
      <Folder>...</Folder>
      <ReadWriteMode>...</ReadWriteMode>
      <Password>...</Password>
   </Attach>
</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	Folder ReadWriteMode Password

Relationship

Element

Parent elements

Child elements

Reference

Detach Element

Attach()

Detach

Concepts

Database Attach and Detach

Database ReadWriteModes

Other Resources

Moving an Analysis Services Database

Switching a database between ReadOnly and ReadWrite modes (Analysis Services)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD