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