Marian Nasry Marian Nasry - 2 months ago 106
SQL Question

Disable warnings and all prints in in sql engine

I have a

sql engine
with main stored procedure that call many other stored procedures , how can i disable all
warnings
and
prints
while executing this engine from job

is there a way to do that without finding all prints and disable them , and what can i do with warnings like
Warning: Null value is eliminated by an aggregate or other SET operation

Answer Source

One way to solve this problem is by turning the warnings off.

SET ANSI_WARNINGS OFF;
GO