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

Answers


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


Need Your Help

Minor Mode for tracking changes in a buffer

emacs

Is there a minor mode in Emacs that will highlight changes made to a buffer? I'm picturing something like highlight tails without a timeout feature. I would use highlight tails for this and chang...

Can't scale multiple paths in Raphael?

javascript html canvas svg raphael

I've tried using the current top Question on SO : Scaling multiple paths with raphael

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.