SqlDbx Forum

SqlDbx

You are not logged in.

#1 2011-07-29 14:18:05

JSH
Member

Retrieving stored procedure code for editing

I'm using SQLDBX 3.5 (Professional edition). When retrieving stored procedure code from the catalog into the editor, code is being truncated from longer stored procedures. This makes it impossible to edit the code, and also impacts the results of searches on the stored procedures, as the missing code is not included in the search.   Is there a maximum size set anywhere that a stored procedure can be in order to be retrieved from the catalog and displayed in the editor?  If there is, is there any way to override the setting?

Offline

#2 2011-07-29 14:29:27

pdrmgbtng
Member

Re: Retrieving stored procedure code for editing

Same for me, I have a procedure with 4,790 lines of code, and only 3,566 lines of code show when I 'Edit Procedure' .

Offline

#3 2011-07-29 14:31:44

sqldbxhelp
Administrator

Re: Retrieving stored procedure code for editing

It looks like we have hard coded limit of 128K for any text column.
This will have to be revisited. In a next couple of days we will have update for 3.50
Let's see if can fix this issue in this release.

Offline

Board footer

Powered by FluxBB