s is a major part of the solution.--====================================================================--===== Setup the synonym in the Dev environment using a 2 part -- naming convention. USE JbmMain_Dev; CREATE SYNONYM dbo.SomeView FOR JbmDB01_Dev.dbo.SomeView;GO--===== Setup the synonym in the QA environment using a 2 part -- naming convention. USE JbmMain_QA; CREATE SYNONYM