sqlcmd in silent mode

Is it possible to run sqlcmd in silent, or quiet mode where the console
window does not appear?

I am setting up an automatic backup system using calls to sqlcmd -Q with
the Windows Task Scheduler. The transaction log backups, especially,
will likely be run as users are working on the application. I do not
want the sqlcmd window to suddenly appear and then dissapear while the
user is working at their computer.

Thanks.

It is not SQLCMD, it is the Windows handling which is the problem. Windows does echo the output when
you execute something. Either have a scheduler with the ability to suppress the console output (like
SQL Server agent does), or perhaps do a little bit of .NET coding and use SMO for the backups?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"John" wrote in message
> Is it possible to run sqlcmd in silent, or quiet mode where the console window does not appear?
>
> I am setting up an automatic backup system using calls to sqlcmd -Q with the Windows Task
> Scheduler. The transaction log backups, especially, will likely be run as users are working on the
> application. I do not want the sqlcmd window to suddenly appear and then dissapear while the user
> is working at their computer.
>
> Thanks.