• fuller.artful (1/20/2009)


    You described well the "how to" aspect of synonyms, but what I fail to grasp its the usefulness. Why would I want to create a synonym? What advantage is gained? By your example, I even have to type an extra keystroke ("1" or "2") when referring to the "Contact" table.

    Thanks,

    Arthur

    This link can answer your query:

    http://www.mssqltips.com/tip.asp?tip=1076