I don't remember how did I such thing...

microsoft.public.sqlserver.programming

15 Dec 2005 5:39 PM

Enric

Dear fellows,

I was wondering how it was for rename a database?

Thanks a lot for any input,
Enric

15 Dec 2005 5:46 PM

Tibor Karaszi

Old way is sp_renamedb. As of SQL Server 2000, you can also (and preferred way) ALTER DATABASE (see
Books Online for syntax).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Enric" <En***@discussions.microsoft.com> wrote in message
news:A10EAC4C-4AA0-4363-A17A-F62E8A66F0F3@microsoft.com...
> Dear fellows,
>
> I was wondering how it was for rename a database?
>
>
> Thanks a lot for any input,
> Enric