Hi folks - Greg Low in particular :-) I have a SQL Server agent job that is failing with error "String data, right truncation [SQLSTATE 01004]". It seems the reason for this is the stored procedure the job calls has a bunch of PRINT statements which I understand find their way through to the job history output window in SSMS. If I remove the PRINT statements the error goes away. Google hasn't helped me much, any SQL Server pros here that have any ideas how to address this?
Thanks Tom