Microsoft KB Archive/263574

= BUG: Design View Displays Views with More Than 4002 Characters Incorrectly =

Article ID: 263574

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q263574



BUG #: 57943 (SQLBUG_70)

BUG # 113833 (VisualStudio)



SYMPTOMS
SQL Server Enterprise Manager (SEM) provides you with the capability of designing or editing the Transact-SQL code of a view. If you use the Design View option to look at a view that has more than 4002 characters, including non-printable characters (that is, '\n' new line and '\r' carriage return), you may see incorrect text or text may be missing. Note that the same issue applies when you use Microsoft Visual Interdev to develop a View.

NOTE: When you look at a View in SEM, SQL Server automatically removes all the comments.



CAUSE
The Design View tool parses the text before it edits the code. The parser has a limitation (approximately 4 kilobytes) on the number of characters it can parse. When the Design View reads and parses the code for the view, part of the date is lost.



WORKAROUND
To work around this behavior and see the full text:

Select the view name, and then double-click the view to view the Properties dialog box of the view.

Now, you can mark the text, and copy and paste into another editor. Other editors include Query Analyzer and tools to debug the view or aid the development of the code.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Additional query words: enterprise manager SEM view

Keywords: kbbug kbpending KB263574

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.