sql server 7.0 - how do i spool?

[thibault]

hi,<br>
i've tried everything. spool, output, output to. i can't find anything in any of the books on how to send output to a text file.<br>
help please<br>
tia,<br>
t <p>bobbie<br><a href=mailto:thibault@hotbot.com>thibault@hotbot.com</a><br><a href=

http://pages.hotbot.com/edu/thibault>

</a><br>today's weather: clowdy 63 fahrenheit

 

[calahans]

Bobbie,<br>
<br>
The only way I have found is by going command line:<br>
<br>
isql -S[your server] -U[login] -P[password] -d[database] -Q[your query i.e select * from master, this is in quotes] -o[output filename]<br>
<br>
Also there is -i input file name (for more than one SQL statement]<br>
<br>
C