Home Forums SQL Server 2005 T-SQL (SS2K5) NTEXT data truncated when run from an Server Agent Job RE: NTEXT data truncated when run from an Server Agent Job
Andy sql
SSCrazy Eights
Points: 9481
More actions
January 15, 2009 at 8:05 am
#927340
Hi Ramesh,
First off, thanks very much for investigating! And you are exactly right, specifying
SET TEXTSIZE { number }
within the Step of the Agent Job solves the problem. Fantastic, many thanks :hehe:
Andy