Export (0) Print
Expand All
Expand Minimize

Database Properties Dialog Box (SSAS - Multidimensional)

Use the Database Properties dialog box in SQL Server Management Studio to set the properties of a database in an Analysis Services database. You can display the Database Properties dialog box by right-clicking a database in Object Explorer and selecting Properties.

Term

Definition

Name

Type to change the name of the database.

ID

Displays the identifier of the database.

Description

Type to change the description of the database.

Create Timestamp

Displays the date and time the database was created.

Last Schema Update

Displays the date and time the metadata for the database was last updated.

Last Update

Displays the date and time the data for the database was last updated.

Data Source Impersonation Info

Select the impersonation information used by the database when connecting to and interacting with data sources contained by the database. Valid values include the following:

ImpersonateAccount (use a specific Windows user name and password).

ImpersonateService (use the service account).

ImpersonateCurrentUser (use the credentials of the current user).

Default (use the service account for MOLAP operations and current user for data mining).

Although you can set data source impersonation settings at the database level, doing so will only affect those data sources that specify Inherit for their impersonation settings. Impersonation settings specified directly on the data source will always override any settings that are specified at the database level.

When choosing an impersonation option, consider the types of operations that will need to be supported. Some operations, such as processing, cannot be performed by

Last Processed

Displays the date and time the database was last processed.

Estimated Size

Displays the estimated size of the database.

Storage Location

Specifies the location of the database. If the database is located in the default Data directory, this value will be empty.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft