HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlModerate

Suppress SQLCMD messages

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
messagessqlcmdsuppress

Problem

Would it be possible to suppress all sqlcmd messages output to the cmd window?

I am running a large script and it seems to be slowed down a lot with all the Processed XXXX total records messages.

The script is over 4Gb so there is a large amount of data.

Solution

You could pipe the results to NUL

C:\>sqlcmd -S localhost -d mydb -i C:\stuff.sql > NUL


I don't see any options in sqlcmd to actually suppress output, just to redirect streams to files.

Code Snippets

C:\>sqlcmd -S localhost -d mydb -i C:\stuff.sql > NUL

Context

StackExchange Database Administrators Q#22026, answer score: 11

Revisions (0)

No revisions yet.