Say you are executing a scheduled job using a batch file and output is stored to a file, then in that output file you will see Warning messages such as SQLSTATE. So how to suppress these messages on the output file. Simply using -i option in SQLCMD as input file by putting the relevant queries in this file, and as usual using -o option for output file. When you execut queries from the SQLAgent job step all the execution results are appended to the output file, so it is better to run this as a SQLCMD...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/11/06/how-to-suppress-sqlstate-messages-when-executing-scripts-using-sqlcmd.aspx