Post reply

Database name change

  • February 4, 2008 at 3:44 pm

    #378337

    Hi,

    How do I change the name of database that has a period(.) in it's name?

    For eg.

    Client.Database

    Thank you.

    Suhas.

  • February 4, 2008 at 3:54 pm

    #774937

    alter database [My.DB] modify name = [My.New.DB.Name]

  • February 4, 2008 at 3:56 pm

    #774938

    The same way you'd rename any database. Either right-click in SSMS and select 'rename' or user sp_renamedb.

    sp_renamedb 'Client.Database', 'NewDatabase'

    or Alter Database

    alter database [Client.Database] modify name = [NewDatabase]

    Greg

  • February 4, 2008 at 4:46 pm

    #774945

    Thanks.

    That was easy. Embarassing for me.

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

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