In Query Analyzer, the option to suppress that is "Print column headers", but that also takes away the column names too. From the command line utilities (isql or osql), the option is "-h-1" to remove headers.

Jay



From: Bowman Rita A.
Sent: Wed 31-Jan-07 06:55
To: LazyDBA Discussion
Subject: RE: How to format text output?


Check the Options in Query Analyzer Tools. I used to get the dashed
lines but don't anymore. I turned off Column Aligned under the Results
tab and they were gone.

Rita
-----Original Message-----
From: danamack
[mailto:mssqldba-ezmlmshield-x98411573.[Email address protected]
Sent: Tuesday, January 30, 2007 3:59 PM
To: LazyDBA Discussion
Subject: Re: How to format text output?


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


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page