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

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