Changing Database Names

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715843

    Comments posted to this topic are about the item Changing Database Names

  • Jeff Moden

    SSC Guru

    Points: 994663

    Whether you use the old or new method, there's a whole lot more to it if you really want to do it right.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71401

    Jeff Moden wrote:

    Whether you use the old or new method, there's a whole lot more to it if you really want to do it right.

    Agreed

    However, it is a good question. really made me think...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • mike.sortino

    Mr or Mrs. 500

    Points: 525

    hmmm -- I have used sp_renamedb in the past without any issues, and it still works. I think it is wrong to post multiple answers that are both OK.  I now realize that the stored procedure is in maintenance mode, but sometimes you need to cut us old timers some slack.

     

    OK -- now I went back and reread the question.  At first I did not see the "in a way that will be supported in the future".  My bad!

    • This reply was modified 4 months, 1 week ago by  mike.sortino.

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

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