Re: Rename database

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 08:45:32 +0200

... or in SQL2K, ALTER DATABASE. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message news:u2KB8NdUEHA.760@TK2MSFTNGP12.phx.gbl...
> sp_renamedb
>
> Look up the details in BOL (Books On-Line)
>
> -- 
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> I support the Professional Association for SQL Server
> www.sqlpass.org
>
> "Dolphin" <d@d.com> wrote in message
> news:uU7ukMdUEHA.2844@TK2MSFTNGP12.phx.gbl...
> > Is there any simple way to rename database?
> >
> >
>
>

Relevant Pages

  • Re: problem with query moving data from 1 dbase to another.
    ... You register a SQL Server instance, where such an instance can have several databases. ... Tibor Karaszi, SQL Server MVP ... > you know how to connect to an existing database, ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Creating Database (Urgently need help)
    ... Senior Database Administrator ... I support the Professional Association for SQL Server ... >>Geoff N. Hiten ... >>>>physical disk NOT in the list cannot be used for SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: error 80020009 HELP!!!
    ... Check your SQL Server event logs for any problems. ... Mike Epprecht, Microsoft SQL Server MVP ... > when they try to access the database through a web browser. ... > info by performing a database restore? ...
    (microsoft.public.sqlserver.server)
  • Re: View Security
    ... SQL Server MVP ... Columnist, SQL Server Professional ... The user can see list of other users who can login into the database. ... able to see all database structue such as view/table/sp definitions. ...
    (microsoft.public.sqlserver.security)
  • Re: How do I Allow SQL DB dump job through a firewall?
    ... I'll try to setup a process that grabs the database on a regular basis after ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)