Post reply

change the physical database name

  • November 19, 2004 at 6:34 pm

    #84779

    Can you change the physical database name in SQL Server 2000?

  • November 19, 2004 at 9:07 pm

    #530943

    Yes, you can do it with stored procedure:

    sp_renamedb [ @dbname = ] 'old_name' ,

        [ @newname = ] 'new_name'

    or in Enterprise Manager.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply