Error 2812 cannot find stored procedure

Hi all

I get the following error Executed as user: 'service account'. Could not find stored procedure 'up_stored_procedure'. [SQLSTATE 42000] (Error 2812). The step failed when I execute up_stored_procedure. The stored procedure exists in the correct database and I also connect to the right database before executing the stored procedure. I have not seen the error before and i've run out of ideas at the moment. Has anyone seen this behaviour before and how do I go about correcting the issue. Thanks

yes i did and got the same response.

did you check the username under which the SP was created?

-- example

create procedure test.test1
as
select * from b

exec test1

the above would throw an error as the test1 proc exists under the login test.

Thanks,
Ram

"It is easy to write code for a spec and walk in water, provided, both are freezed..."

the owners of both sp and job is dbo

Any parameters that the sp is expecting?

all the parameters was supplied

In Enterprise Manager, on the Properties for the SQL Server instance, go to Security, and check the Startup Service Account setting at the bottom of the tab.

the database was not an upgrade from MS Access. I managed to find out that sql was case sensitive so had to change things around and it worked. Thanks all for your response much appreciated.

Good catch!

There was a thread recently on case sensitive collations, where I was surprised to learn that it also applied to database object names.