How can you get SQLCMD, when executing a SQL script file, to just output any errors or warnings it encounters?
I essentially dont want information based messages to be output.
Found this on SQLServerCentral
The following will work:
The output from the query will be put into the log and nothing is printed on the screen.
In the case of an error, it will run like this:
More details at the MSDN article on sqlcmd.