Why I can't see my procedure code? How to display it

[expired user #6811]'s profile image [expired user #6811] posted 11 years ago in General Permalink
Hi all,

I use the heidiSQL to connect to my database.

In the database there are already plenty of well-coded stored procedure.

I can see them in the left tree of heidiSQL, but when I click on the procedure, I can't see any code on the procedure console, the options, parameters and create code pages are all empty and it seems that I can create the already existing procedure from scratch.

But the procedures are definitely there, because I can write queries to execute those procedure from heidiSQL.

It's so weird that I can't see any code but I can execute procedures, and it's very inconvenient that I have to go back to SQL Server to see what parameter I need. Maybe I have been looking at the wrong place for procedure code this whole time.

So how could I let the heidiSQL to display the procedure code?
ansgar's profile image ansgar posted 11 years ago Permalink
What server is it, and what's the HeidiSQL revision you are using? I have recently fixed some stored routine bug, and introduced such a new bug along with that fix.
[expired user #6811]'s profile image [expired user #6811] posted 11 years ago Permalink
I'm using sql server 2008, and heidiSQL 7.0
ansgar's profile image ansgar posted 11 years ago Permalink
I meant the *revision* of HeidiSQL, not the major release version. But I guess that makes no difference here, as I did not manage to make the routine editor fully compatible to MS SQL yet. See issue #2490.
[expired user #6811]'s profile image [expired user #6811] posted 11 years ago Permalink
then that would be the installer(mirror), an exe
[expired user #6811]'s profile image [expired user #6811] posted 11 years ago Permalink
Thanks, anse,
that's exactly what I see when I want to use a procedure on HeidiSQL.
So this problem could not be fixed right now :(

Please login to leave a reply, or register at first.