OK Synonyms are not new in SQL, they were introduced back with SQL Server 2005, but to date I’ve never got round to using them until now. A synonym is really just a shortcut reference to a object (Table, View, Stored Procedure or Function) that resides in a database on another server that you have defined...