patternsqlModerate
Suppress SQLCMD messages
Viewed 0 times
messagessqlcmdsuppress
Problem
Would it be possible to suppress all
I am running a large script and it seems to be slowed down a lot with all the
The script is over 4Gb so there is a large amount of data.
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
I don't see any options in sqlcmd to actually suppress output, just to redirect streams to files.
C:\>sqlcmd -S localhost -d mydb -i C:\stuff.sql > NULI 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 > NULContext
StackExchange Database Administrators Q#22026, answer score: 11
Revisions (0)
No revisions yet.