Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stored procedure error Expand / Collapse
Author
Message
Posted Tuesday, February 10, 2009 3:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 3, 2010 7:34 AM
Points: 26, Visits: 70
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
Post #653539
Posted Tuesday, February 10, 2009 5:27 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 14,459, Visits: 37,984
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!
Post #653593
Posted Tuesday, February 10, 2009 5:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 3, 2010 7:34 AM
Points: 26, Visits: 70
Thanks i will check this out
Post #653597
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse