Showing posts with label thomas. Show all posts
Showing posts with label thomas. Show all posts

Friday, March 30, 2012

Renaming Analysis DB

Hi

Is it possible to rename an analysis db on analysis services 2000?

Thanks in advance

Thomas

It's been a while since I've messed with 2000, but I do not believe you can change the name. Take a look at the DSO object library to see the the database name can be changed there. If not, then I think you're out of luck.

One solution is to open the AS manager, right-click the database, select copy then paste, and provide a new name. You'll need to reprocess (and possibly remove the old database), but this is how we used to handle this problem.

Good luck,
Bryan

|||

Hi Brian

This works for me. Thank you very much.

Thomas