Hi

I'm trying to use this command from my workstation to see the direcory exist or not in the share directory. It doesnt give me the desired output. Though the file exist, i'm getting the return value 0

execute master..XP_FILEEXIST '\\MachineName\test'

Fileexist File Is A Directory Parent Directory Exists
0 0 0

Please help me on this issue.

Thanks,
Chandra

__________________
Thanks,
Chandra

If you put \\MachineName\test into the run line can you reach that directory?

XP_FileExist will not list files... you must supply a file name in the command.

Try this to get a list of files in the directory...

EXEC Master.dbo.XP_Dirtree '\\MachineName\Test',1,1

--Jeff Moden