xp_cmdshell 'dir G:\' don't show all subdir' in directory
Posted on 2003-02-24
I'm trying to validata file existance in a local directory in my computer. I'm executing this procedure through Sql Analizer and this is the exact syntax:
exec xp_cmdshell 'dir G:\'
The output shows only 1 subdirectory but not the others.
When i'm typing the same command through dos, it works fine and shows all the directories.
The operating system is win2k, sql server is standard edition.
Thanks in advance,