SQLServer 6.5 - How do I rename a database

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I am reducing the size of a database using 'Transfer Objects' into a new smaller database. I would like to retain the original database with a new name and create the smaller db with the original name. Can this be easily done ?

-- Anonymous, May 02, 2001

Answers

Mark,

Have you considered using sp_renamedb?

Hope this helps,

Eric

-- Anonymous, May 02, 2001


Many thanks - I am a novice on SQLServer and the Microsoft Administrators Companion makes no mention of this stored procedure!

-- Anonymous, May 03, 2001

Moderation questions? read the FAQ