Home Forums SQL Server 2005 Administering 1 sp out of 4 not executing even though user has execute permissions on all 4 RE: 1 sp out of 4 not executing even though user has execute permissions on all 4

  • January 7, 2013 at 11:22 am

    #1574445

    Does the table involved in the insert, or any of the tables in the non-functioning sp, have deny permissions for the users or role?

    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