Is there a way to suppress the "x lines affected" in SQLCMD from the command line?

Question

Is there a way to suppress the "x lines affected" in SQLCMD from the command line?

I am running an MSBuild script and do not want it to clog my log on my build server.

I would prefer not to add “SET NOCOUNT ON” to every script, so if there is a way to do this from the command line, it will be fantastic.

Answer 1

How about creating a script run using SET NOCOUNT ON in the script (assign the script to the SQLCMDINI environment variable). http://msdn.microsoft.com/en-us/library/ms162773.aspx

Answer 2

The -i and -q options are mutually exclusive .

Create a file called setnocount.sql with the contents:

 SET NOCOUNT ON; 

And you can do -i setnocount.sql,otherscript.sql using the multiple file function and effectively "including" the common first file.

Answer 3

You can also run multiple lines in the -Q option, separated by a semicolon, as shown below

eg:

 -Q "set nocount on;select * from table;delete from table where some_condition=true"