memo field truncates when SP is run from sql server agent

Question

Post reply

memo field truncates when SP is run from sql server agent

pjengel

SSC Journeyman

Points: 86
More actions
April 17, 2008 at 1:38 am

#128619

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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

David-250683 Hall of Fame Points: 3452 More actions · Answer 1

David-250683

Hall of Fame

Points: 3452

April 25, 2008 at 4:24 pm

#807434

Script out the job from Enterprise Manager and post here.

Steve Jones - SSC Editor SSC Guru Points: 728159 More actions · Answer 2

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)?

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com