Make sure you test it out with synonyms.
Your requirement makes sense.
Still the DBA has to apply caution and vigilance. If the db mapping is wrong, the code will no longer "complain".
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/