rename logical name**

Hi
How can I rename the name of logical name of my Database?
is it possible in SQL server 2000?
any help would be greatly thankfulRM
Alter DATABASE in the BOL
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsapjtykahqligo@.msnews.microsoft.com...
> Hi
> How can I rename the name of logical name of my Database?
> is it possible in SQL server 2000?
> any help would be greatly thankful|||Hi,
Did you mean to rename the logical name of MDF and LDF. Then use
alter database DBNAME modify file (NAME = 'old_MDF_NAME', NEWNAME ='NEW_MDF_NAME')
do the same for LDF file as well.
For renaming the database.
alter database OLD_DB_NAME modify name = new_db_name
--
Thanks
Hari
MCDBA
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsapjtykahqligo@.msnews.microsoft.com...
> Hi
> How can I rename the name of logical name of my Database?
> is it possible in SQL server 2000?
> any help would be greatly thankful|||Hi,
with ALTER DATABASE statement you can change logical name of database.
ALTER DATABASE database_name
MODIFY NAME = new_database_name
Ana
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsapjtykahqligo@.msnews.microsoft.com...
> Hi
> How can I rename the name of logical name of my Database?
> is it possible in SQL server 2000?
> any help would be greatly thankful