Microsoft KB Archive/147829

= PRB: sp_helptext Appears to Add  to Creation Script Result =

Article ID: 147829

Article Last Modified on 3/26/1999

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition

-



This article was previously published under Q147829



SYMPTOMS
When you use sp_helptext to look at the creation script of a view, rule, default, stored procedure, or trigger, an extra carriage return is added to the results following every 255 characters.



CAUSE
The creation script for some objects are stored in the syscomments system table in a column defined as varchar(255), so the object will have one row for every 255 characters in its creation script. When sp_helptext returns the results to the client application, the client application usually formats the results by adding a carriage return to the end of each row.



RESOLUTION
Use a client application built to edit views, rules, defaults, stored procedures and triggers, such as SQL Object Manager or SQL Enterprise Manager.

Additional query words: sql6 sproc

Keywords: kbusage KB147829

-

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

© Microsoft Corporation. All rights reserved.