Home > DeveloperSection > Forums > Stored Procedure doesn't exist, or does it?
Ankita Pandey
Ankita Pandey

Total Post:183

Posted on    September-04-2013 2:24 AM

 C# C# 

 1 Reply(s)
 960  View(s)
Rate this:

I have a db connection where I run stored procedures on. This same connection is used to create said stored procedures earlier on.

When I attempt to call a given stored procedure, later on, I get the following message:

Could not find stored procedure 'dbo.yaf_prov_upgrade'.

The problem is it actually does exist on the database. And there's also the fact that it shows up on the SQL Server Profiler.

RPC:Completed exec [dbo].[yaf_prov_upgrade] @PreviousVersion=46,@NewVersion=46 .Net SqlClient Data Provider Nico Matrix\Nico

I was wondering what could be the causes a particular query would throw such an exception even when it exists, it's called, and the call reaches the database.

It can't be a problem with the connection because it already executed other stored procedures. It can't be a problem with the procedure because it does exist, in fact the very same application, the very same web page, created it and put it there.

Update: forgot to mention I'm used integrated security, and I did run the SP on the database with the same user the application connects with, and I had no problem running it.

So what can it be?

Sumit Kesarwani

Total Post:378

Posted on    September-04-2013 7:03 AM

Hi Ankita,

Your RPC completed only means that the batch submitted to SQL Server was correct and completed. It doesn't mean the stored procedure ran and executed OK.

It will be (don't argue, check) one of:

wrong permissions

wrong database context

wrong server

stored proc is in a different database

To ensure that things are the same







The OBJECT_ID will be NULL if the stored proc doesn't exist in that database or you don't have permissions.

Don't want to miss updates? Please click the below button!

Follow MindStick