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
精彩评论