Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Yesterday @ 2:35 PM
Points: 12,962, Visits: 32,498
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
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