x

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

jhunu gravatar image

jhunu
90 29 30 31

(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

http://msdn.microsoft.com/en-us/library/ms365349.aspx

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

http://richardlees.blogspot.com/2009/06/analysis-services-database-name-and.html

http://blogs.msdn.com/b/sqlcat/archive/2007/07/30/renaming-olap-databases-issues-within-analysis-services.aspx
more ▼

answered Jan 04, 2012 at 07:07 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x172

asked: Jan 04, 2012 at 04:59 AM

Seen: 556 times

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