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 ?
As per BOL
For more information please visit
Moreover, there are some issues with changing the names worth mentioning. For that do visithttp://blogs.msdn.com/b/sqlcat/archive/2007/07/30/renaming-olap-databases-issues-within-analysis-services.aspx
answered Jan 04, 2012 at 07:07 AM