SqlDbx Forum

lantian

Member

Edit database procedures, triggers, functions problem

The right mouse button click on the left side of the database in any of the procedures, triggers, functions edit, Script window display content is missing, not display completely.

Alt+F1 (procedures properties、triggers properties、 functions properties) The same problem

Embodied in the multi-line case, such as right of 91 lines, after using the Sqldbx EDIT lines show only to 53 and 53 lines with missing characters

Sqldbx v3.62  or v2.63  Have this problem
Sqldbx v3.58  Normal, no this problem

Is Sqldbx v3.6x Personal Edition version to limits the database  procedures properties、triggers properties、 functions properties  (procedures, triggers, functions edit)  in the character number or line number ?

Last edited by lantian (2013-11-21 03:25:44)

sqldbxhelp

Administrator

Re: Edit database procedures, triggers, functions problem

This is  an issue with latest release and Sql Server.
It happens when you use old version of Sql Server driver to connect to newer version of Sql Server (bug in Microsoft driver).
Your option either upgrade your driver or wait for next release.

lantian

Member

Re: Edit database procedures, triggers, functions problem

hello!

not entirely SQL Server Driver problem,I was installed on a SQL Server Native Client 10.0 (sqlncli10. DLL ver 2009.100.4000.0) a test on the computer found that the problem still exists, originally may appear afore-mentioned problems, before may be within 100 lines appear afore-mentioned problems, In SQL Server Native Client is installed after the problems of the after the 600 line

not installed  SQL Server Native Client
Sqldbx v3.58
test:91 lines
result:normal

test:677 lines
result:normal

Sqldbx v3.63
test:91 lines
result:Only show the lines 53 and 53 did not show complete

test:677 Lines
result:Only show the lines 49 and 49 did not show complete

installed  SQL Server Native Client 10.0 (sqlncli10. DLL ver 2009.100.4000.0) after
Sqldbx v3.58
test:91 lines
result:normal

test:677 lines
result:normal

Sqldbx v3.63
test:91 lines
result:normal

test:677 Lines
result:Only show the lines 645 and 645 did not show complete

Before and after using the same procedures
SQL Server 2008 R2

Last edited by lantian (2013-11-22 05:40:05)

sqldbxhelp

Administrator

Re: Edit database procedures, triggers, functions problem

Thank you very much for your test.
I am not able to reproduce the issue.
I do not have exact version of sqlncli10.dll.
If you do not mind can you please zip it and email to support at sqldbx.com

lantian

Member

Re: Edit database procedures, triggers, functions problem

Sorry!

I use a Chinese version of the test may not be suitable for you
You can be in SQL Server Developer Center
Get the SQL Server Native Client for SQL Server 2008 SP3
http://www.microsoft.com/en-us/download … x?id=27596

And how much the number of characters,  2009 around contain Spaces
The same number of rows, number of different characters in different rows missing
test  procedures:

CREATE  PROCEDURE [test001] 
@test DateTime output
AS
--	1	test test test test test test test test test test test test test test test test test test test test  test test
...(fill 2-1124)
--	1125	test test test test test test test test test test test test test test test test test test test test  test test
GO

CREATE  PROCEDURE [test002] 
@test DateTime output
AS
--    1    test
...(fill 2-1124)
--    1125    test
GO

Last edited by lantian (2013-11-22 22:51:23)

lantian

Member

Re: Edit database procedures, triggers, functions problem

Only to find that http://sqldbx.com/forum/viewtopic.php?id=566 And my problems are the same.

Thank you very much! 3.64 the issue has been resolved.

btw: I now use computer (not test the computer) running environment does not change (not install any SQL Native Client)

Last edited by lantian (2013-11-25 23:56:16)