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

avatar image

jhunu
110 29 30 35

(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

avatar image

Usman Butt
14k 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x197

asked: Jan 04, 2012 at 04:59 AM

Seen: 677 times

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

Copyright 2016 Redgate Software. Privacy Policy