Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    25

    Unanswered: Procedure to align syscomments text

    Hi DB Experts,

    Is there a procedure available to align the text column of syscomments table?

    I get the output as follows
    c
    reate procedure pr_generate_text
    as
    begin
    declare @temp varchar(1
    0)
    ---
    --
    ---
    --
    END

    But I want the output to look like this
    create procedure pr_generate_text
    as
    begin
    declare @temp varchar(10)
    ---
    --
    ---
    --
    END
    Regards,
    Poornima.
    Last edited by J.Poornima; 03-01-07 at 08:56.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Use ddlgen utility instead
    else see sp__helptext (2 underscores) from http://www.edbarlow.com/gem/procs/
    Standalone Download

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •