Hi Christine0701,
I found the same problem even after these ANSI settings before the procedure compilation.
But I have got a workaround.
I just turned on these ANSI settings (ANSI Nulls and ANSI warnings) for the whole database using sp_dboption. Now the SQL job is working fine...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.