• 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.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]