Post reply

changing a database name in Enterprise Manager

  • November 6, 2003 at 5:35 am

    #82537

    Can a database name be changed within Enterprise Manager? (Win 2000, SQL 2000)

    E.g. from "dynamicthis" to "dynamic"?

    Thanks!

    Edited by - mikeperrett on 11/06/2003 05:36:46 AM

  • November 6, 2003 at 5:49 am

    #481050

    no.

    see sp_renamedb in bol

    Cursors never.

    DTS - only when needed and never to control.


    Cursors never.
    DTS - only when needed and never to control.

  • November 26, 2003 at 11:57 am

    #483806

    If your databases is being published you won't be able to do it even with sp_renamedb.

  • November 26, 2003 at 2:26 pm

    #483825

    have a look at ALTER DATABASE


    * Noel

  • December 2, 2003 at 3:04 am

    #484226

    Thanks all - the sp_renamedb did the trick for me

    --Mike

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

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