From: Joe on
On Dec 9, 2:56 pm, "Bob Barrows" <reb01...(a)NOyahoo.SPAMcom> wrote:
> Joe wrote:
> > On Dec 9, 2:00 pm, "Bob Barrows" <reb01...(a)NOyahoo.SPAMcom> wrote:
> >> Joe wrote:
> >>> I am building a small helper application to create a table, stored
> >>> procedures and triggers. I need to output the SQL formatted instead
> >>> of all together.
>
> >> "Output" it where? In your HTML? If so, you either need to use the
> >> <PRE> tag, or use <br> for your line breaks.
> >> --
> >> HTH,
> >> Bob Barrows
>
> > No, the problem seems to be that when I use,
>
> > select name as 'Trigger', object_name(parent_obj) as 'Table'
> > from sysobjects
> > where xtype = 'TR'
>
> > to view the trigger in the database, the trigger is really unreadable,
> > which is hard to troubleshoot.  Is there anyway to do this?
>
> View it where? in SSMS? or, if it's pre-2005 SS, Query Analyzer?
>
> How did the text get into the sysobjects table? Was it input into your
> html page? if so, what kind of element was used? Whatever you are doing
> to receive the input from the user and pass it to the database is
> causing the whitespace to be stripped
> --
> HTH,
> Bob Barrows

Just a note...

The triggers and sps work fine... there is no problem there at all,
but viewing and working with them is a pain considering they are just
lumped together.

Thanks,
Drew