how to retrieve full text of procedure definition from syscomment

Hello,
I am trying to locate where/when data is being inserted into a table from a
DB I recently inherited. So I write this in QA
select * from syscomments where
text like '%Insert Into CompareSubscribers%'
This will retrieve the procedure(s) that contains the text "...Insert
Into..." But when I select that text field from QA Results, and paste it
into Notepad, I only get the characters before the first carriage retuen.
How can I retrieve the full text? Or if I stretch out the field in QA
Results grid - it only stretches to the first carriage return in the text.
Thanks,
RichHi Rich
Why don't you try returning the results in text format instead of grid? And
only select the text column:
select text from syscomments where
text like '%Insert Into CompareSubscribers%'
Make sure you configure QA to return the full column width.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:164BF9D0-FEDE-4B37-8CAE-9A8F7257F118@.microsoft.com...
> Hello,
> I am trying to locate where/when data is being inserted into a table from
> a
> DB I recently inherited. So I write this in QA
> select * from syscomments where
> text like '%Insert Into CompareSubscribers%'
> This will retrieve the procedure(s) that contains the text "...Insert
> Into..." But when I select that text field from QA Results, and paste it
> into Notepad, I only get the characters before the first carriage retuen.
> How can I retrieve the full text? Or if I stretch out the field in QA
> Results grid - it only stretches to the first carriage return in the text.
> Thanks,
> Rich