PRB: sp_helptext Appears to Add <CR> to Creation Script Result (147829)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 3/26/1999 |
|---|
| Keywords: | kbusage KB147829 |
|---|
|