Analysis Services

In Analysis services , under the tab Database , their are few databases name. On Right Click , we get few options like name :- xxxx. ID - xxxx.

I need to modify the Id from XXXX to YYYY.

How it can be done. Can it be done using generate Alter Script and then execute it ?

more ▼

asked Jan 04, 2012 at 04:59 AM in Default

avatar image

110 29 30 36

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

As per BOL

The manner in which you change the name of a Microsoft SQL Server Analysis Services database depends upon how you connect to the Analysis Services database. To change the name of an existing database, you must connect in online mode. To change the name of the database into which objects in an Analysis Services project will be instantiated, you must connect in project mode

For more information please visit


Moreover, there are some issues with changing the names worth mentioning. For that do visit



more ▼

answered Jan 04, 2012 at 07:07 AM

avatar image

Usman Butt
13.9k 6 13 21

You can change the name with an alter script but you cannot change the ID.

Jan 04, 2012 at 11:36 AM Scot Hauder
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 04, 2012 at 04:59 AM

Seen: 677 times

Last Updated: Jan 04, 2012 at 05:02 AM

Copyright 2017 Redgate Software. Privacy Policy