Post reply

Working with Synonym on Scalar Functions

  • November 19, 2008 at 4:58 am

    #196089

    Hi all,

    I Have a bit unusual environment and have some problems with Synonyms.

    I have a main productions Server (2005 ENT).

    That server uses Mirroring to copy data to a second server.

    Since the DBs in the second server are on Restoring state, I created Snapshots on those DBs for the DEV & QA dept.

    Each Dept. owns her own DB on the second server, and for the need to retreive data from the snapshot (through scalar functions), I created Synonyms to those functions.

    The only problem is when I try to run the function through the Synonym, I get an error message:

    Cannot find either column "dbo" or the user-defined function or aggregate "dbo.'SynonymName' ", or the name is ambiguous.

    I tried to use prefix (schema name before the Synonym name), tried to use DB Name and nothing!

    I can't use the function through the Synonym (I must say that Synonyms pointing to tables, work just fine).

    Is there anything I should know when creating or using Synonyms to functions?

    Please help.

    THank you,

    Oz

  • November 19, 2008 at 11:34 pm

    #900890

    No one knows?!

    There must be a solution for creating Synonyms on functions.

    :ermm:

  • November 20, 2008 at 2:51 am

    #900937

    Never mind... I found the problem and the solution.

    Thanks anyway,

    Oz

  • December 12, 2008 at 1:48 am

    #911505

    whats your solution?Can you post.I have similar such problem.Will check whether your solution can be used.

  • January 29, 2009 at 3:24 am

    #934482

    I had the same problem, but have not found a solution yet

    The cause

    http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=370335

    If someone has found a workaround I'd appreciate them posting it.

    I'm currently using OPENQUERY(LinkedServerName,'Select [DatabaseName].[SchemaName].[UDFName](ParameterValue)') as a workaround, but would prefer to access to the linked servers to be in Synonyms for consistency.

  • August 15, 2011 at 3:09 pm

    #1368854

    anyone found this solution? I am stuck with this issue and really need some fix soon.

    Thanks!

  • May 23, 2012 at 10:23 am

    #1491908

    can u post the solution its very urgent!!!!

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy