Post reply

Stored procedure error

  • February 10, 2009 at 3:47 am

    #205198

    Executed as user: AOANHSS\sqlnashrep. Could not find stored procedure 'AxSP_Adhoc_PerformConsistencyCheck'. [SQLSTATE 42000] (Error 2812). The step failed.

    I am getting this error from a failed backup on SQL 2005 i have checked and the stored procedure is in programability i have never dealt with any stored procedures so any help would be appreciated. The jobs were set up by a third party

    Thanks

  • February 10, 2009 at 5:27 am

    #941107

    does the stored procedure AxSP_Adhoc_PerformConsistencyCheck exist in the master database, or the default database of the user AOANHSS\sqlnashrep?

    if it exists in master, but the default database for AOANHSS\sqlnashrep is "DevDB", you'd get this kind of error.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 10, 2009 at 5:39 am

    #941111

    Thanks i will check this out

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

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