June 25, 2008 at 1:29 pm
Hello world! =)
i have some problem with
"EXEC master.dbo.xp_cmdshell 'dir \\servername\anyfolder\*.*'
The result:
17/01/2008 09:58 a.m. .
17/01/2008 09:58 a.m. ..
17/01/2008 09:58 a.m. Erroneos
Note that getme a time with dots (a.m.) but if i execute a dir command from DOS (on the server) the result is:
06/25/2008 12:35 AM .
06/23/2008 20:00 PM POLSUC23062000.TXT
I want set the result on same time mode.
Any ideas?
Thanks in regards,
Federico.
June 25, 2008 at 8:51 pm
Are the regional settings the same for each server (check via Control Panel)? Check the time/date formats as well.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
June 26, 2008 at 10:57 am
Yes I ckecked the regional options on server, the solution key was apply the option [Default User Account Settings] from Advanced option under Regional and Language options (if you don´t check this option, the regional formats still working like at the previous moment).
Thanks for all guys.
Federico.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply