Changing Database Names

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738043

  More actions

  June 6, 2019 at 12:00 am

  #3632274

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

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  June 6, 2019 at 5:20 am

  #3650668

  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.

  Change is inevitable... Change for the better is not.
  

  ---

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

• Stewart "Arturius" Campbell

  SSC Guru

  Points: 72716

  More actions

  June 6, 2019 at 5:44 am

  #3650672

  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: 544

  More actions

  June 6, 2019 at 1:41 pm

  #3650763

  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 5 years, 12 months ago by mike.sortino.