What about creating a startup script with SET NOCOUNT ON in the script (assign the script to the SQLCMDINI environment variable). http://msdn.microsoft.com/en-us/library/ms162773.aspx
Open a command prompt window. If you have a default instance of SQL Server already running, run the following command on the command prompt to stop the SQL Server service: net stop mssqlserver Now go to the directory where SQL server is installed. The directory can for instance be one of these: C:\Program Files\Microsoft SQL … Read more
You can run something like this: sqlcmd -S MyServer -d myDB -E -Q “select col1, col2, col3 from SomeTable” -o “MyData.csv” -h-1 -s”,” -w 700 -h-1 removes column name headers from the result -s”,” sets the column seperator to , -w 700 sets the row width to 700 chars (this will need to be as … Read more