开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜