I am maintaining a classic ASP website that has a SQL Server 2005 backend. For a small piece of new functionality I wrote a stored procedure to do an insert. This is the only user stored procedure in the database.

我正在维护一个经典的ASP网站，有一个SQL Server2005后端。对于一小部分新功能，我编写了一个存储过程来执行插入。这是数据库中唯一的用户存储过程。

When I attempt to call the stored procedure from code I get the following error:

当我尝试从代码中调用存储过程时，我得到以下错误：

Microsoft OLE DB Provider for SQL Server error '80040e14' 
Could not find stored procedure 'InsertGroup'. 
/newGroup.asp, line 84 

The DB uses SQL Server authentication. When I connect to the DB server in Visual Studio using the same user/pw as in the connection string the stored procedure is not visible but all tables are.

数据库使用SQL Server身份验证。当我在Visual Studio中使用与连接字符串中相同的用户/pw连接到DB服务器时，存储过程不可见，但所有表都可见。

The user has datareader and datawriter roles and explicit execute permission on the stored procedure.

该用户具有DataReader和DataWriter角色，并对存储过程具有显式执行权限。

What am I missing?

我遗漏了什么？

UPDATE: My apologies, the server admin misinformed me that it was a 2000 server when it is actually a 2005 server (running on Windows Server 2003 x64).

更新：对不起，服务器管理员误导我说它是2000服务器，而实际上它是2005服务器(运行在Windows Server2003x64上)。

优秀答案推荐

Walk of shame:

羞耻之行：

The connection string was pointing at the live database. The error message was completely accurate - the stored procedure was only present in the dev DB. Thanks to all who provided excellent answers, and my apologies for wasting your time.

连接字符串指向实时数据库。错误消息完全准确--存储过程只存在于开发数据库中。感谢所有提供出色答案的人，并对浪费您的时间表示歉意。

You may need to check who the actual owner of the stored procedure is. If it is a specific different user then that could be why you can't access it.

您可能需要检查存储过程的实际所有者是谁。如果它是一个特定的不同用户，那么这可能是您无法访问它的原因。

Sometimes this can also happen when you have a stored procedure being called with parameters. For example, if you type something like:

有时，当使用参数调用存储过程时也会发生这种情况。例如，如果您键入如下内容：

set @runProc = 'dbo.StoredProcedure'
 exec @runProc

This will work, However:

然而，这将是可行的：

set @runProc = 'dbo.StoredProcedure ''foods'''
exec @runProc

This will throw the error "could not find stored procedure dbo.StoredProcedure 'foods'", however this can easily be overcome with parantheses like so:

这将抛出错误“找不到存储过程dbo.StoredProcedure‘Foods’”，但是这可以很容易地用下面这样的段落来克服：

set @runProc = 'exec dbo.StoredProcedure ''foods'''
exec (@runProc)

make sure that your schema name is in the connection string?

确保您的架构名称在连接字符串中？

There are 2 causes:

原因有两个：

1- store procedure name
When you declare store procedure in code make sure you do not exec or execute keyword
for example:

1-存储过程名称在代码中声明存储过程时，请确保不使用EXEC或EXECUTE关键字，例如：

C#

C#

string sqlstr="sp_getAllcustomers";// right way to declare it.

string sqlstr="execute sp_getAllCustomers";//wrong way and you will get that error message.

From this code:

在此代码中：

MSDBHelp.ExecuteNonQuery(sqlconexec, CommandType.StoredProcedure, sqlexec);

MSDBHelp.ExecuteNonQuery(sqlconexec，CommandType.StoredProcedure，sqlexec)；

CommandType.StoreProcedure will look for only store procedure name and ExecuteNonQuery will execute the store procedure behind the scene.

CommandType.StoreProcedure将只查找存储过程名称，而ExecuteNonQuery将在后台执行存储过程。

2- connection string:

2-连接字符串：

Another cause is the wrong connection string. Look inside the connection string and make sure you have the connection especially the database name and so on.

另一个原因是连接字符串错误。查看连接字符串，确保您有连接，特别是数据库名称等。

I had:

我有：

USE [wrong_place]

使用[错误位置]

GO

去

before

在此之前

DECLARE..

宣布..。

Could not find stored procedure?---- means when you get this.. our code like this

找不到存储过程？-意思是当您获得此..我们的代码如下

String sp="{call GetUnitReferenceMap}";

stmt=conn.prepareCall(sp);

ResultSet rs = stmt.executeQuery();

while (rs.next()) {

currencyMap.put(rs.getString(1).trim(), rs.getString(2).trim()); 

I have 4 DBs(sample1, sample2, sample3) But stmt will search location is master Default DB then we will get Exception.

我有4个数据库(sample1，sample2，sample3)，但stmt将搜索位置为主默认数据库，然后我们将得到异常。

we should provide DB name then problem resolves::

我们应该提供数据库名称，然后问题解决：：

String sp="{call sample1..GetUnitReferenceMap}";

One more possibility to check. Listing here because it just happened to me and wasn't mentioned;-)

还有一种可能性需要检查。在此列出是因为这件事发生在我身上，没有人提到；-)

I had accidentally added a space character on the end of the name.
Many hours of trying things before I finally noticed it. It's always something simple after you figure it out.

我不小心在名字的末尾加了一个空格。我尝试了很多小时才终于注意到这一点。在你弄清楚之后，事情总是简单的。

I had the same problem. Eventually I found why. I used a code from web to test output of my procedure. At the end it had a call to Drop(procedure) so I deleted it myself.

我也有同样的问题。最终我找到了原因。我使用Web上的一段代码来测试程序的输出。最后，它有一个删除(程序)的调用，所以我自己删除了它。

If the error message only occurs locally, try opening the sql file and press the play button.

如果错误消息仅在本地出现，请尝试打开SQL文件并按播放按钮。

My answer according to the problem and what is causing it for me
when i called stored procedure just there is a space before the stored procedure name.
Sometimes it just takes checking the simplest needs

根据问题以及是什么原因，我的答案是，当我调用存储过程时，存储过程名称前有一个空格。有时只需要检查最简单的需求

 datatabel = dataAccessLayer.ReadDataFromDB(" Get_All_Customers",null);

when i deleted the space before Get_All_Customers it's work finely

当我删除Get_All_Customers之前的空间时，它工作得很好

Assuming you are using C# and ADO.NET, It can happen if you don't set SqlCommand.CommandType to CommandType.Text.

假设您使用的是C#和ADO.NET，如果不将SqlCommand.CommandType设置为CommandType.Text，就可能发生这种情况。