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

  • 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