I using an osql statement below and want my output file to have a width of 642. Output is line wrapping and I'm not sure what I'm doing wrong. Any suggestions?
declare @cmd as varchar(255)
declare @cmdshell_result as int
set @cmd = 'osql -Q"sp_mcc_il_cigs" -E -d"Order" -W642 -n -oc:\ILReturn.txt'
exec @cmdshell_result = master..xp_cmdshell @cmd,no_output
declare @cmd as varchar(255)
declare @cmdshell_result as int
set @cmd = 'osql -Q"sp_mcc_il_cigs" -E -d"Order" -W642 -n -oc:\ILReturn.txt'
exec @cmdshell_result = master..xp_cmdshell @cmd,no_output