InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 01:42:20 GMT20http://www.sqlservercentral.com/Forums/Topic653539-359-1.aspxThanks i will check this outTue, 10 Feb 2009 05:39:33 GMTlittle1http://www.sqlservercentral.com/Forums/Topic653539-359-1.aspxdoes 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.Tue, 10 Feb 2009 05:27:53 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic653539-359-1.aspxExecuted 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 partyThanksTue, 10 Feb 2009 03:47:15 GMTlittle1