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.
Also, how is the data truncated? Are you sure there's enough space in the destination table? When you say available, does that mean it's copied correctly or that it's viewable on the screen.
Is the data always truncated in the same location (size)?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply