@SQLDork continues to make my brain hurt with questions like these – Ed.
So i’m doing my usual set of work, and i think to myself, “What would happen if i made two registered server entries that point to the same server?”. Naturally, i asked Kevin (b|t) for his thoughts on it, and naturally, he told me to test it, so i did:
Running SELECT @@Servername against both these groups gives these results:
Interestingly enough, there’s that _2 appended to the second copy of server SQLPD07, which means somebody at Microsoft (t) thought this same thing at some point, so they included it in the SSMS code.
Thanks for reading,
Kevin and Liz