I have a job. Step 1 of the job looks like this:
declare @sql varchar(8000)
select @sql = 'bcp "exec FOOBAR.dbo.ExportDNCToSpectrum" queryout c:\inetpub\ftproot\DNC\CoDNCForRiseFS02.csv -c -t, -T -S'+ @@servername
exec master..xp_cmdshell @sql
the SP "ExportDNCToSpectrum" is suddenly raising an arithmetic overflow error, however this isn't causing the job to fail. So basically I had no idea for weeks that anything was wrong. I've tried adding Set ANSI_WARNINGS ON in both the SP and the job step but to no avail. What gives. What am i doing wrong.