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