InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 11:14:07 GMT20http://www.sqlservercentral.com/Forums/Topic1412457-391-1.aspxNope, you have to synonym every object:[LiveServer].[Databade].[TheSchema].[ObjectName1] --> [DevServer].[Databade].[TheSchema].[ObjectName1][LiveServer].[Databade].[TheSchema].[ObjectName2] --> [DevServer].[Databade].[TheSchema].[ObjectName2]etc.Mon, 28 Jan 2013 10:12:01 GMTScottPletcherhttp://www.sqlservercentral.com/Forums/Topic1412457-391-1.aspxthanks a lot for the replies guysMon, 28 Jan 2013 09:15:13 GMTerics44http://www.sqlservercentral.com/Forums/Topic1412457-391-1.aspxSynonyms can be created for the following types of objects:Assembly (CLR) Stored ProcedureAssembly (CLR) Table-valued FunctionAssembly (CLR) Scalar FunctionAssembly Aggregate (CLR) Aggregate FunctionsReplication-filter-procedureExtended Stored ProcedureSQL Scalar FunctionSQL Table-valued FunctionSQL Inline-table-valued FunctionSQL Stored ProcedureViewTable (User defined) - Includes local and global temporary tablesMon, 28 Jan 2013 08:25:21 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1412457-391-1.aspxnope a synonym must point to an [b]object [/b]( an object that would exist in a databases[b] sys.objects[/b] view), and not part of the name of an object.so by definitions, it is typically used for tables , views etc. very handy for aliasing four part objects, like CREATE SYNONYM myTable FOR OtherServer.Databasename.dbo.TablenameMon, 28 Jan 2013 08:23:51 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1412457-391-1.aspxHiI have a dev database and a live databaseboth have linked servers to other databases in the dev environments and live environmentsI would like to know if it is posible to create a synonym to a schema rather than an objectso In the dev database my synonym would be created something likecreate sysnonym Server.TheSchema for [DevServer].[Databade].[TheSchema]and in livecreate sysnonym Server.TheSchema for [LiveServer].[Databade].[TheSchema]This way I would only need to alter the information in my synonym rather than each time i reference a table.I know the about doesnt work so i was hoping that there was a way.ThanksMon, 28 Jan 2013 08:18:47 GMTerics44