Hello

I use command OSQL and i have in output file strong character when i use the command xp_cmdshell


test.sql

DECLARE @cmd sysname, @var sysname

SET @var = 'd:\mssql7\data'

SET @cmd = 'dir ' + @var

EXEC master..xp_cmdshell @cmd
I use this osql
osql -U sa -P GD6Dsa -S %SERVEUR% -i test.sql -o backup.log -b

and the oupput file :backup.log

there is stong character like '˙' ,
R‚p
WHY ?



R‚pertoire de d:\mssql7\data



NULL



12/09/03 12:05 <DIR> .



12/09/03 12:05 <DIR> ..



26/09/03 19:29 2˙097˙152 Coffre.ldf



26/09/03 19:29 2˙097˙152 Coffre.mdf



27/08/03 14:19 2˙886˙721 coffre.zip



16/09/03 14:05 1˙048˙576 Etiquettes_Data.MDF



16/09/03 14:05 12˙320˙768 master.mdf



16/09/03 14:05 5˙308˙416 mastlog.ldf



16/09/03 14:05 1˙048˙576 model.mdf



16/09/03 14:05 786˙432 modellog.ldf



16/09/03 14:05 8˙388˙608 msdbdata.mdf



16/09/03 14:05 786˙432 msdblog.ldf



16/09/03 14:05 1˙048˙576 northwnd.ldf



16/09/03 14:05 3˙801˙088 northwnd.mdf



16/09/03 14:09 112˙197˙632 oscar_Donn‚es.MDF



26/09/03 19:29 3˙879˙731˙200 oscar_Donn‚es2.MDF



26/09/03 19:29 112˙132˙096 oscar_Donn‚es3.MDF



16/09/03 14:09 1˙310˙720 oscar_Journal.LDF



26/09/03 19:29 1˙310˙720 oscar_Journal2.LDF



26/09/03 19:29 1˙310˙720 oscar_Journal3.LDF



16/09/03 14:05 1˙835˙008 pubs.mdf



16/09/03 14:05 786˙432 pubs_log.ldf



25/09/03 15:48 63˙176˙704 TEMPDB.MDF



16/09/03 14:47 786˙432 TEMPLOG.LDF



24 fichier(s) 4˙216˙196˙161 octets



491˙745˙280 octets libres




(31 lignes affect‚es)