How can i copy the code only from a stored procedure and execute it as a normal sql statement? Is this possible?
Open up the Database Browser and go to the procedure you want. Select the script tab. This will show you the proceedure contents. There should be a tool button that will send this to the editor. Here you can execute or tweak it as a template for a new procedure.
If you only want to execute the procedure there is an execute proceedure tool button that will prompt for parameters and execute.
Thank you! Worked great.