Hi All,

I need to create a text file, which contains query result, and send to other
users. I found that the text content of the text file I created using OSQL
command wrapped to a second line if the text length is longer than say 100
characters. I need to create a text file in which the length of each content
line is much longer than 300 characters. What can I do to get want I need?

The following is the command I used.

Select @Output_File = 'Osql -Q "Select Id, Location, Status, Reason from
database..Temp_No_Email order by Id" -E -o ' + @File_1_Name

Please check the attached sample file and any tip is appreciated.


Thanks,

Feng





<<No_Email_Address.txt>>



*******************************************************************************
Important - This email and any attachments may be confidential. If received in
error, please contact us and delete all copies. Before opening or using
attachments check them for viruses and defects. Regardless of any loss, damage
or consequence, whether caused by the negligence of the sender or not, resulting
directly or indirectly from the use of any attached files our liability is
limited to resupplying any affected attachments. Any representations or opinions
expressed are those of the individual sender, and not necessarily those of the
Department of Education & Training.
id Location Status Reason
-------- -------- ----------- ----------------------------------------
11111111 111111 T No Email Address
22222222 222222 T No Email Address

(2 rows affected)
MS Sql Server LazyDBA home page