Thanks Tommy, sorry for such a simple answer. I was to focused on the .Net connector and that just did not work.

Thanks again.

thanks so much 

It looks like the only way to do this with osql is to do the following:

osql -E -d pubs -q "select * from dbo.authors" >junk.txt -h-1

then I write a...

This worked great, I found the options, any idea how to set them in a SQL proc?