• ndevr (5/14/2012)


    whats is the best practice for prod server Named Instance or Default instance? Please suggest (Pros and cons)

    Thanks!

    Personally, I find no benefit to having a named instance if you only will have 1 instance. If you have more than 1 instance, it is up to you whether or not to have 1 default and other named or just to make them all named. Really, there aren't many general pros and cons.

    Jared
    CE - Microsoft