I have a stored procedure which loops thru about 180 tables and inserts the data into one table used for reporting purposes. One field is a memo field. If I execute the stored procedure from query analyzer the entire contents of the memo field is available. When I run as scheduled task (every 1/2 hour) the data in the memo field is truncated.