sqlsql-serversuppress-warnings

How do I suppress T-SQL warnings when running a script SQL Server 2005?


Is it possible to suppress warnings generated by T-SQL scripts? If so, how?

I know I can turn of the 'records affected' messages with

SET NOCOUNT ON

but is there an equivalent for warnings? Eg:

Warning: Null value is eliminated by an aggregate or other SET operation.

If I'm expecting these errors, it helps to sift the real errors from the chaff in a big script.

Thanks.


Solution

  • See SET ANSI_WARNINGS {ON | OFF}