Stored Procedure Creation via SQL assistant

General
Enthusiast

Stored Procedure Creation via SQL assistant

Hi

I am trying to create a stored procedure and I need to learn if it can be done via SQL assistant. Its a simple procedure takes in 2 values compares them sends out result of the greater number. The challenge I am facing is that the create statement gets completed when I use F9 . However neither does the Tool Show me it's definition nor I am able to call it says procedure does not exist. How can it say procedure created and still its not found ... Pls help . Thx in advance!!

Regards

Harry

1 REPLY
Enthusiast

Re: Stored Procedure Creation via SQL assistant

Harry,

It can be done using SQLA.

Are you qualifying your create procedure statement as well as your show procecdure statement with the database name ?

Possibly a default database issue.

Rglass