Based on my SQL Server 2000 experience, you either need to write dynamic SQL, which you don't want to do, or you need the view, which will have to be re-generated when you want to change which database it is connecting to.
While there was something about synonyms in SQL Server 2000 they definately did not work like aliases in Oracle and I never found a use for them.
It looks like they have improved synonyms in SQL Server 2005, but I haven't check them out, but look for them in Books On-line and you might find what you want.
Brian