无效的对象名称 sql server 存储过程 [英] Invalid object name sql server stored procedure

问题描述

我在尝试修改现有存储过程时收到此错误.无效的对象名称 [dbo].[BackupDB]"

I am getting this error while trying to modify the existing stored procedure. "Invalid object name [dbo].[BackupDB]"

我能够创建此存储过程，但是当我单击修改选项以修改此存储过程时，系统向我显示了上述错误.您会看到附加的图片.

I was able to create this stored procedure but when I click on modify option to modify this stored procedure system shows me the above error. You see the attached image.

我在尝试执行此命令时也遇到同样的错误.它不会找到 BackupDB

Also i am getting same error when try to execute this command. It won't find BackupDB

EXEC BackupDB @backupLocation='C:\SQLBackups\', 
                              @databaseName=’wmas_subs’, @backupType='F'

http://i61.tinypic.com/6oj32s.png

推荐答案

尝试刷新Management Studio上的Stored Procedure文件夹

Try to refresh the folder of Stored Procedure on your Management Studio

这篇关于无效的对象名称 sql server 存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！