Home Forums SQL Server 2008 SQL Server 2008 - General create synonym to schema RE: create synonym to schema

  • January 28, 2013 at 10:12 am

    #1581709

    Nope, you have to synonym every object:

    [LiveServer].[Databade].[TheSchema].[ObjectName1] --> [DevServer].[Databade].[TheSchema].[ObjectName1]

    [LiveServer].[Databade].[TheSchema].[ObjectName2] --> [DevServer].[Databade].[TheSchema].[ObjectName2]

    etc.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.