How to change Database name in SQLServer?

I want to change some Databases' name. But the only way I know is backup the
database, and change another name when recovering it. Is there any other way
that is easier than that below? thanks
zlfYou can do it using ALTER DATABASE
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"news.microsoft.com" <zlfcn@.hotmail.com> wrote in message
news:OsHwjN4LFHA.3500@.TK2MSFTNGP14.phx.gbl...
>I want to change some Databases' name. But the only way I know is backup the
> database, and change another name when recovering it. Is there any other way
> that is easier than that below? thanks
> zlf
>|||Thank you!
zlf
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> дÈëÏûÏ¢
news:#vyABZ4LFHA.3852@.tk2msftngp13.phx.gbl...
> You can do it using ALTER DATABASE
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "news.microsoft.com" <zlfcn@.hotmail.com> wrote in message
> news:OsHwjN4LFHA.3500@.TK2MSFTNGP14.phx.gbl...
> >I want to change some Databases' name. But the only way I know is backup
the
> > database, and change another name when recovering it. Is there any other
way
> > that is easier than that below? thanks
> >
> > zlf
> >
> >
>|||sp_renamedb
"news.microsoft.com" wrote:
> I want to change some Databases' name. But the only way I know is backup the
> database, and change another name when recovering it. Is there any other way
> that is easier than that below? thanks
> zlf
>
>