Renaming a dB

ioates · July 2nd, 2003, 02:31 AM

Hopefully this is a simple question. I want to rename a SQL Server 2K database. E.g. from NorthwindBU to Northwind

Is it possible

Thanks
Ian

David Cameron · July 2nd, 2003, 02:41 AM

sp_renamedb [@old_name =] 'old_name',
[@new_name =] 'new_name'

eg:
sp_renamedb 'NorthwindBU', 'Northwind'

regards
David Cameron

melvik · July 2nd, 2003, 02:45 AM

sp_renamedb 'Old_Name' , 'New_Name'

Always:),
Hovik Melkomian.

ioates · July 2nd, 2003, 02:48 AM

Thanks guys, those lovely system SPs. Sorry for not using BOL :-)