i using sql server 2005 on client site. in past have created stored procedures in no problem. last stored procedure created not show in object explorer under "stored procedures". tried saving , w/o dbo.
if try save new stored procedure, name of 1 not displayed in object explorer appears option in "save file as" picklist.
it added bottom of tree when execute/add stored procedure. refresh stored procedure folder in tree sort alpha order.
also ensure creating stored procedure on database executing code create procedure before procedure name. if need edit procedure simple modify (right click procedure in explorer tree) , change create procedure alter procedure.
Comments
Post a Comment