Storedprocedures in formatted Output using sp_helptext

• • Reply

  13 years ago

  by rajchekar

  rajchekar

  , India

  Joined 15 years ago

  Dear Developers ,

                            I'm using sql-server2005. I want ot take the content of a storedprocedure using the command 'Sp_helptext' . It gives the Whole content without format. I mean if i copy the content and i will create in another database without any format change(allignment). can you?

  for ex:

        below is the O/p of a SP:

           create procedure ex_proc (  Begin t

                                                    ry)

  But i need

    create procedure ex_proc (  Begin try)

  Plz, Help me..

  Is there any Command to get a formatted o/p.

  Tahnks in advance

  Raju

  Report abuse