sp_helptext has been enhanced to regenerate formatted SQL text for compiled objects, identical to the SQL text for the compiled object when it was created. This also allows the user to generate a fragment of SQL source by providing a starting line number and a context block window that specifies the number of lines displayed. For complete documentation of sp_helptext, see the Reference Manual: Procedures. For information about the new parameters, see “sp_helptext”.
