September 29, 2003 at 4:09 am
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)
September 30, 2003 at 6:05 am
I executed same commands on my server, but I got result like this
Volume in drive C has no label.
Volume Serial Number is 6CC9-81D5
Directory of C:\Program Files\Microsoft SQL Server\MSSQL\data
09/25/2003 06:19p <DIR> .
09/25/2003 06:19p <DIR> ..
09/29/2003 07:00p 1,048,576 CLARIFY_Log.LDF
12/17/2002 02:55p 786,432 distmdl.ldf
12/17/2002 02:55p 2,359,296 distmdl.mdf
09/29/2003 10:29p 1,048,576 MAINT_SITE_Log.LDF
09/04/2003 11:59a 16,121,856 master.mdf
09/04/2003 11:59a 2,359,296 mastlog.ldf
09/19/2003 12:56a 655,360 model.mdf
09/19/2003 12:56a 524,288 modellog.ldf
09/26/2003 07:30p 15,204,352 msdbdata.mdf
09/19/2003 12:56a 2,359,296 msdblog.ldf
09/19/2003 12:56a 1,048,576 northwnd.ldf
09/19/2003 12:56a 2,752,512 northwnd.mdf
09/25/2003 06:14p 6,881,280 pubs.mdf
09/25/2003 06:14p 8,585,216 pubs1_log.ldf
09/25/2003 06:19p 516,096 pubs_log.LDF
09/23/2003 07:12p 13,565,952 tempdb.mdf
09/25/2003 07:24p 8,585,216 templog.ldf
17 File(s) 84,402,176 bytes
2 Dir(s) 6,177,226,752 bytes free
Madhu
Madhu
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply