SQLCMD - how to Suppress output

microsoft.public.sqlserver.tools

22 Oct 2006 5:59 PM

sdragolov

Is it possible to suppress/turn-off the output that is returned from
queries within a script when executing it with sqlcmd utility ?? I
don't want to write the output to a file, just want to turn it off.

Or is the only way to make it into a stored procedure?

Thanks.

22 Oct 2006 10:51 PM

Erland Sommarskog

(sdrago***@gmail.com) writes:

> Is it possible to suppress/turn-off the output that is returned from
> queries within a script when executing it with sqlcmd utility ?? I
> don't want to write the output to a file, just want to turn it off.

You could redirect output to NUL: to lose it entirely.

Or are there pieces in the output you do want to see?

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx