PRB: sp_helptext Appears to Add <CR> 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