Job Truncates Data

Transact-SQL
8

So I finally found the reason to this. I have to insert this line before the EXECUTE inside the Job:

SET TEXTSIZE 2147483647;

Crazy!

Found the answer here:

1 Like