Post reply

Possible reasons for EXECUTE permission error

  • September 16, 2011 at 8:00 am

    #96429

    Hi ,

    My application in prod fails everyday at a particualr time with the error

    EXECUTE permission was denied on the object "UDF_GetName",

    it runs fine during other timings, could some one please help?

    Thanks,

    Giri

  • September 16, 2011 at 8:06 am

    #1382562

    Have you checked for other running jobs at that time?

    Is the udf being snapshot replicated to the server you are working from?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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