View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0007665VALENTINA STUDIOStored Procedurespublic2016-05-18 15:422016-05-19 14:00
ReporterAndyMarshman Assigned Toyuriy_velichko  
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformINTELOSMAC OS OS Version*
Product Version6.4.x 
Target Version6.5.xFixed in Version6.5.x 
Summary0007665: Not showing SQL Server stored procedures properly
DescriptionWhen I open an SQL Server stored procedure in the SQL Editor it only contains between 50 and 60 lines.
Steps To ReproduceOpen any SQL Server 2008 stored procedure that has over 50 lines.
TagsNo tags attached.
Working with DB:SQL Server
Version of your DB:2008

Relationships

has duplicate 0007667 closedyuriy_velichko Stored Procedure Edit from MS-SQL Server 2012 

Activities

yuriy_velichko

yuriy_velichko

2016-05-18 16:06

reporter   ~0009066

By default SQL Server returns limited amount of bytes.
Can you try to increase this option via Studio preferences?

Preferences -> Plugins -> MSSQL -> Data Limit
AndyMarshman

AndyMarshman

2016-05-18 16:16

reporter   ~0009067

I've tried increasing the limit. Even at 10,000,000 bytes it still returns exactly the same number of lines of the stored procedure.
yuriy_velichko

yuriy_velichko

2016-05-18 17:11

reporter   ~0009068

Confirmed.
Thanks for the report.
We will fix this issue in nearest time.
yuriy_velichko

yuriy_velichko

2016-05-18 17:52

reporter   ~0009069

fixed in version 6.5.4
Still need to increase Data limit according to user purposes.
yuriy_velichko

yuriy_velichko

2016-05-18 18:44

reporter   ~0009070

Andy, by the way, as temporary fix, you can execute in the SQL Editor for particular database

SET TEXTSIZE 1000000

In result the function text will be loaded as expected. Maybe will be needed to refresh the function.

Issue History

Date Modified Username Field Change
2016-05-18 15:42 AndyMarshman New Issue
2016-05-18 16:06 yuriy_velichko Note Added: 0009066
2016-05-18 16:16 AndyMarshman Note Added: 0009067
2016-05-18 17:10 yuriy_velichko Assigned To => yuriy_velichko
2016-05-18 17:10 yuriy_velichko Status new => assigned
2016-05-18 17:11 yuriy_velichko Note Added: 0009068
2016-05-18 17:52 yuriy_velichko Note Added: 0009069
2016-05-18 17:52 yuriy_velichko Status assigned => resolved
2016-05-18 17:52 yuriy_velichko Fixed in Version => 6.5.x
2016-05-18 17:52 yuriy_velichko Resolution open => fixed
2016-05-18 18:40 yuriy_velichko Status resolved => feedback
2016-05-18 18:40 yuriy_velichko Resolution fixed => reopened
2016-05-18 18:44 yuriy_velichko Note Added: 0009070
2016-05-18 18:45 yuriy_velichko Target Version => 6.5.x
2016-05-18 18:45 yuriy_velichko Status feedback => resolved
2016-05-18 18:45 yuriy_velichko Resolution reopened => fixed
2016-05-19 14:00 yuriy_velichko Relationship added has duplicate 0007667