Database Element (ASSL)

Defines a Microsoft SQL Server 2005 Analysis Services (SSAS) database.

Syntax

<Databases>
   <Database>
      <Name>...</Name>
      <ID>...</ID>
      <CreatedTimestamp>...</CreatedTimestamp>
      <LastSchemaUpdate>...</LastSchemaUpdate>
      <LastUpdate>...</LastUpdate>
      <Description>...</Description>
      <State>   </State>
      <AggregationPrefix>...</AggregationPrefix>
      <EstimatedSize>...</EstimatedSize>
      <LastProcessed>...</LastProcessed>
      <Language>...</Language>
            <Collation>...</Collation>
      <Visible>...</Visible>
      <MasterDatasourceID>...</MasterDataSourceID>
      <Accounts>...</Accounts>
      <DataSources>...</DataSources>
      <DataSourceViews>...</DataSourceViews>
      <Dimensions>...</Dimensions>
      <Cubes>...</Cubes>
      <MiningStructures>...</MiningStructures>
            <Roles>...</Roles>
      <Assemblies>...</Assemblies>
      <DatabasePermissions>...</DatabasePermissions>
            <Translations>...</Translations>
      <Annotations>...</Annotations>
   </Database>
</Databases>

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

Databases

Child elements

Accounts, AggregationPrefix, Annotations, Assemblies, Collation, CreatedTimestamp, Cubes, DatabasePermissions, DataSources, DataSourceViews, Description, Dimensions, EstimatedSize, ID, Language, LastProcessed, LastSchemaUpdate, LastUpdate, MasterDatasourceID, MiningStructures, Name, Roles, State, Translations, Visible

Remarks

The corresponding element in the Analysis Management Objects (AMO) object model is Database.

See Also

Reference

Server Element (ASSL)
Objects (ASSL)

Help and Information

Getting SQL Server 2005 Assistance