benyos (9/6/2009)
You are absolutely correct.You must use 3 part naming convention (Server.DB.Object) or even 4 part (Server.DB.Schema.Object) in order to get away with it.
If your solution refers to 10 objects than it's convenient. If it has 150 - you're in a setup-script-must-have situation...
Not necessarily - you could always script the creation of the 150 synonyms. Either reading a setup table or reading the catalog on the linked server - or a whole lot of other options.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs