开发者

Stored procedure error::Invalid object name..Need help

开发者 https://www.devze.com 2023-01-28 16:01 出处:网络
fetching data from 2 tables in one Stored Proceure..what\'s wrong with the SP below ? Its giving error as \"Msg 208, Level 16, State 6, Procedure sp_GetID, Line 9

fetching data from 2 tables in one Stored Proceure..what's wrong with the SP below ?

Its giving error as "Msg 208, Level 16, State 6, Procedure sp_GetID, Line 9 Invalid object name 'Admin.sp_GetID'."

ALTER PROCEDURE GetID  
(
 @ID int  
)
AS  
BEGIN  


 SELECT ID FROM Language WHERE ID=@ID  

END   

I am altering a previously made procedure.开发者_JS百科..All I changed was ..I added the second SELECt statment...just that...otherwise SP was executing


Sounds like the procedure doesn't exist. Try changing ALTER to CREATE.


I am hearing this error for the first time please remove [Admin] from [Admin].[sp_GetTelerikLanguageCodeAdminID] in the stored procedure name and execute. I hope it will work i have seen only [dbo] at that place

0

精彩评论

暂无评论...
验证码 换一张
取 消