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...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.