I am running an SQLCMD command from DOS against a SQL Server 2008 database that occasionally outputs the following message at the end of the data:
"WARNING: Null value is eliminated by an aggregate or other SET operation."
I do not control the DB and do not want to fix the error, I just want to suppress the warning message.
I know the default ERRORLEVEL is 0.
If I add the output parameter -m1 this warning disappears. This is what I want because the output is read by a different program and does not expect messages at the end.
But it raises a few other questions for me:
1. What ERRORLEVEL values exist in SQL Server?
2. Do they mean anything?
3. Is there a maximum (if I want to suppress any/all errors)?