SqlDbx
You are not logged in.
Pages: 1
It seems the Unicode version for 3.45 works properly, but for the non-Unicode version...
When I right click a procedure and select "Script EXECUTE", and that proc has arguments, it pops up the argument box like "Execute...", rather then pasting the script to the opened tab.
Jason Lipman
Offline
If procedure takes parameters then the window should pop up and ask for argument values.
Also I believe some improvements where implemented for scripting in one of the later versions.
Offline
I can see that if there are arguments, the scripting works, but I would still like to have it for EXECUTEs that do not have arguments. Perhaps we are just grabbing the EXECUTE logic to paste somewhere else so we can run it later on the fly. I think there is value in having the ability to generate syntax quickly when I want it. In my opintion, it should not matter that there are arguments or not. - Jason
Offline
Now you confuse me.
There's two option on a menu. One is "Execute ..." and second "Script Execute".
Offline
The "Script Execute" Should paste a script into the window, correct? IE: EXECUTE dbo.sp_proc {args}.
If there are no arguments, it is not pasting. I would like the EXECUTE dbo.sp_proc to still paste, even if there are no arguments.
Jason
Offline
It should paste it without arguments too. What is your database?
Offline
Pages: 1