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

Rename

Hi,
Can i rename a DB ' does anyone know any workaround for
this'
Thanks in advance
CMLCsp_renamedb
Changes the name of a database.
Syntax
sp_renamedb [ @.dbname = ] 'old_name' ,
[ @.newname = ] 'new_name'
>--Original Message--
>Hi,
>Can i rename a DB ' does anyone know any workaround for
>this'
>Thanks in advance
>CMLC
>.
>|||CMLC
In SQL 2000 use the alter database command, in SQL 7 or
before use sp_renamedb. See BOL for full details.
Hope this helps
John|||> Can i rename a DB ' does anyone know any workaround for
> this'
sp_dboption [oldName], 'single user', 'TRUE'"
sp_renamedb [oldName], [newName]
sp_dboption [newName], 'single user', 'FALSE'"
hth
--
// myLittleTools.net : leading provider of web-based applications.
// myLittleAdmin : online MS SQL manager
// http://www.mylittletools.net
// webmaster@.mylittletools.net