Re: rename logical name**

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ana Mihalj (amihalj_at_hotmail.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 10:58:05 +0200

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

Relevant Pages

  • Re: Can I move tempdb?
    ... ALTER DATABASE should be 'templog'. ... MODIFY FILE, ... > ALTER DATABASE tempdb ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Error
    ... In SQL 2000 you can use alter database to rename the logical ... (or relocate) ... To change the physical file, you can do what Tom suggested ...
    (microsoft.public.sqlserver.clients)
  • Re: Renaming a database
    ... It is a stored procedure / TSQL Command. ... rename the db if no user is conencted. ... ALTER DATABASE <Dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE ...
    (microsoft.public.sqlserver.setup)
  • Re: Renaming a database
    ... It is a stored procedure / TSQL Command. ... rename the db if no user is conencted. ... ALTER DATABASE <Dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE ...
    (microsoft.public.sqlserver.setup)
  • Re: rename logical name**
    ... Alter DATABASE in the BOL ... > How can I rename the name of logical name of my Database? ... > is it possible in SQL server 2000? ...
    (microsoft.public.sqlserver.server)