output to a text file from "sql server"

[thibault]

i know how to spool in oracle. at every other forum people keep telling me how to spool in oracle. i want to spool in sql server. any of you guys know how? say &quot;yes&quot;.<br>
thanks<br>
b <p>bobbie "in chicago"<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]

Hi Bobbie,<br>
<br>
If you want to output text from sql server you need to do it through a command line:<br>
<br>
isql -S[servername] -d[database] -i[input file of SQL] -O[output file]<br>
<br>
This is a very rough idea (I don't have access to SQL Server at the moment). Type isql /? at your command prompt to find the exact format. I have used this myself and it worked fine.<br>
<br>
C<br>
<br>
today's weather: dire, outlook: bleak