找不到存储过程'dbo.InsertUpdateLocation'。 SQL SERVER 2008 [英] Could not find stored procedure 'dbo.InsertUpdateLocation'. SQL SERVER 2008

问题描述

嗨..



我正在使用远程连接的数据库，当我尝试使用存储过程时出现以下错误 - 无法找到存储过程'dbo。 InsertUpdateLocation'。



我尝试从dbo更改模式名称，但问题仍然存在，并且在本地运行完美。



任何人都可以帮助我吗？



提前致谢。

Hi..

I am using remotely connected database and when i try to use the stored procedures getting the following error- Could not find stored procedure 'dbo.InsertUpdateLocation'.

I tried changing the schema name from dbo but the problem still exists and it works perfectly fine in local.

Can anyone please help me??

Thanks in advance.

推荐答案

当您将其移动到生产数据库时，您是否记得将存储过程复制过来？因为错误消息是非常明确的 - 如果你没有在本地和生产之间更改代码，那么有一个明显的原因......

When you moved this to your production database, did you remember to copy the stored procedure over? Because the error message is quite explicit - and if you haven't changed the code between local and production, then there is one obvious cause...

错误 - 找不到存储过程' dbo.InsertUpdateLocation'当您编写未获取此存储过程时会生成此类错误。

因此，请检查数据库是否创建了此过程。或者确保匹配存储过程名称正确。

error- Could not find stored procedure 'dbo.InsertUpdateLocation' This type of error generate when you code not getting this store procedure.
So check you data base did you create this procedure.Or make sure match store procedure name properly.

最简单的方法是在服务器中执行存储过程的脚本。

Simplest way will be to execute script for stored procedure in server.

这篇关于找不到存储过程'dbo.InsertUpdateLocation'。 SQL SERVER 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！