April 1, 2011 at 7:53 am
I create a stored procedure and save it - the save dialog points to the "Projects" folder, so that's where I save it. I try to run the procedure and the error message "can't find stored procedure" comes up.
I have all necessary permissions, that I can see. Frustration level high - any help is appreciated.
April 1, 2011 at 7:58 am
You have saved the procedure in a folder. But did you create the procedure in database?
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 1, 2011 at 8:01 am
Under the database, Programmability, Stored Procedures, I right click and choose New Stored Procedure.
April 1, 2011 at 8:08 am
If you can see the sp in the same place, right click on that sp and click execute. If it is working previously you might be chosen a different database in the query editor.
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 1, 2011 at 8:56 am
No, it's not there. Any idea why it won't save under Stored Procedures? I create views and schemas and I can see them under those areas.....
April 1, 2011 at 9:01 am
First right click on the stored procedure node and click refresh.
Still the sp is not there means, you have only saved the sp in a file, but you have NOT created that sp in database. Open that saved sp in a query editor and select the proper database in drow down list and press F5 (or click execute button). Then sp will be created in the database and you can see the sp under that stored procedure node.
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 1, 2011 at 9:15 am
You rock so hard C.K. - thanks! I'm trying to learn this amid too many interruptions.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply