Re:

osql -i test.sql -e -b -r 1 > temp.log

I intend to use osql to submit a bunch of SQL scripts from
a batch file.

If the SQL script has an error, the message is logged with
a line number. But the echoed input does not have line
numbers. Instead, the SQL text is preceded by a line that
looks like:

1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
18> 19> 20> 21> 22> 23>

The above looks to me like the line numbers without the
text. The text is successfully echoed after that, but
with out line numbers.

Is there any way to get the text echoed to the log file
with line numbers?

Hi

I don't think you can do exactly what you want. -n will turn of the N>
prompts and -m can set the error level to display.

John

"Randy" <anonymous (AT) discussions (DOT) microsoft.com> wrote