• RBarryYoung (5/14/2012)


    I always use named instances, because I never know for sure if I may need to add another instance (permanently or temporarily) on the current server.

    Since, as already noted, you cannot rename them, I find it easier to just give them all unique names. That way, if I ever need to have two instances temporarily reside on the same server, it's no problem.

    Just curious... What changes with your scenario if you have to add an instance? I, personally, still don't see any issues. If you have to have temporarily reside on the same server, there is still no issue with 1 named and 1 default.

    Jared
    CE - Microsoft