Query Analyzer - not printing output

[Marcus]

Is there something that can be set in SQL to not print output to the
screen? Something like SET NOCOUNT ON, only in this case, I don't
want it to print any output except what my script specifies in PRINT
statements. Any ideas? Thank you.

[Simon Hayes]

"Marcus" <mj*****@yahoo.com> wrote in message
news:7d**************************@posting.google.c om...

Is there something that can be set in SQL to not print output to the
screen? Something like SET NOCOUNT ON, only in this case, I don't
want it to print any output except what my script specifies in PRINT
statements. Any ideas? Thank you.

Not all output and messages can be avoided - can you give an example of the
output you don't want to see? You might also want to look at using OSQL.EXE
with an output file.

Simon

[Raghuraman]

Hi,

set no count on

will only suppress the total recrds read by the query .But i don't
think will eliminates the visibility of the query result.

[Marcus]

Thanks for your feedback.

I wrote a batch file to be run from query analyzer for use by would-be
developers (much like myself). In order to get the final output to
the users, I issue quite a few select statements. When they see all
the output from various select statements, they get confused.

I'm using dynamic sql to execute the select statements. Actually, if I
knew how to issue "exec('select count(*), etc. " into variables using
dynamic sql, I wouldn't have the problem of trying to suppress output.
But I can't seem to get that working.

Marcus
"Simon Hayes" <sq*@hayes.ch> wrote in message news:<3f**********@news.bluewin.ch>...

"Marcus" <mj*****@yahoo.com> wrote in message
news:7d**************************@posting.google.c om...

Is there something that can be set in SQL to not print output to the
screen? Something like SET NOCOUNT ON, only in this case, I don't
want it to print any output except what my script specifies in PRINT
statements. Any ideas? Thank you.

Not all output and messages can be avoided - can you give an example of the
output you don't want to see? You might also want to look at using OSQL.EXE
with an output file.

Simon