Post reply

Stored Procedure Error

  • March 30, 2012 at 11:24 am

    #271252

    Hi all,trying to run a Stored Procedure on a 2008 SQL data from a desktop machine via Microsoft Access and get this error message:

    Could not find ddo.member-update (Stored Procedure) or you dont have permission.

    Thanks for any help.:-)

  • March 30, 2012 at 11:28 am

    #1467108

    davidshephard (3/30/2012)

    Hi all,trying to run a Stored Procedure on a 2008 SQL data from a desktop machine via Microsoft Access and get this error message:

    Could not find ddo.member-update (Stored Procedure) or you dont have permission.

    Thanks for any help.:-)

    Can you "see" the storedproc? do you have privs to execute it?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • March 30, 2012 at 11:31 am

    #1467111

    Where is this done at?

    Thanks.

  • March 30, 2012 at 11:42 am

    #1467115

    Contact your SQL Server DBA and ask him/her if your credentials are good to execute such storedproc.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • March 30, 2012 at 11:44 am

    #1467117

    it may also be DBO.sp_name not DDO. may try that before bugging the dba but if thats not it i think that is the only course of action.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • March 30, 2012 at 12:21 pm

    #1467126

    Dash is not supported character in object names, without escaping, so if it is dbo then try it like this

    dbo.[member-update]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 6 posts - 1 through 5 (of 5 total)

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