Stored procedure error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » Stored procedure error

Stored procedure error

Rate Topic

Display Mode

Topic Options

Author

Message

little1

Posted Tuesday, February 10, 2009 3:47 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, September 03, 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

Lowell

Posted Tuesday, February 10, 2009 5:27 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:41 PM
Points: 11,648, Visits: 27,760

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

little1

Posted Tuesday, February 10, 2009 5:39 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, September 03, 2010 7:34 AM
Points: 26, Visits: 70

Thanks i will check this out

Post #653597

« Prev Topic | Next Topic »

Permissions