Microsoft SQL Server 7.0 Question

[Whitebat]

I need some help when i do select * from table1 ; then i get a result like

column1 column2 columnetc.
- - - - - - - - - - - - - - - - - - - - - - - - - -
bla bla bla

now here is my question is there a way to get the result without the column name ( a - instead will be ok) and without the - - - - -?

Thanks for your help

 

[SimonA]

Query -> Current Connection Options

Select the 'Advanced' tab

Un-tick 'Print Headers'

Simon.

 

[Whitebat]

But unfortunately i need it in a script. somethinh like set print headers off or so ? is there something like that??