PRB: sp_helptext Appears to Add <CR> to Creation Script Result

 Last reviewed: May 2, 1997
Article ID: Q147829

The information in this article applies to:
  • Microsoft SQL Server, version 6.0

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 : kbbug6.00 kbtool kbusage SSrvEntMan SSrvStProc
Version : 4.21 6.0
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.