Home Forums SQL Server 2012 SQL 2012 - General Renaming a named instance of SQL 2012 RE: Renaming a named instance of SQL 2012

  • May 27, 2015 at 8:36 am

    #1800960

    Dimbulbz (5/27/2015)

    Huh, I tried running the upgrade(Express to Full) from the install disk like he said in the article, and I got the message that "there is no upgrade path from SQL Express to this version of SQL server" - I thought this would be the only way to get there. I havent checked the Express version to be sure its 2012. Perhaps its a 2008 edition. That would make sense. You have to be able to upgrade from Express to Standard right?

    Love the SP_Drop_Contractor idea. Can you send me the code? 😀

    Unfortunately I'm also a contractor - but have had this client for about 10 years.

    I'm a contractor too. Sorry, but I haven't written that SP yet. 😉

    Pointing a well designed app to a new data source should be so easy. You should be able to just edit the config data and update the source server and/or database name(s). I guess not all apps are well designed. 🙁


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]