I discovered that setting
set nocount on
supresses the row count from being displayed in the output file.

If I execute the script as a stored procedure - do you think that might supress the lines that appear between query results?

-Dana

-------------- Original message --------------
From: [Email address protected]

I have a long script that executes several sql statements. In the resulting file there are dashed lines
- - - - - - - - - - - - - - - - - - - - - -
that separate each statements' results.
- - - - - - - - - - - - - - - - - - - - -
How can I get rid of these lines?

thanks,
Dana

MS Sql Server LazyDBA home page