|
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 ?
(comments are locked)
|
|
As per BOL
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 You can change the name with an alter script but you cannot change the ID.
Jan 04 '12 at 11:36 AM
Scot Hauder
(comments are locked)
|
