Ah-ha. gotcha. Wonderful and thanks. Where did you locate this info. I did searches on "xp_fileexist" in MSDN Library, SQL Books Online and MSDN at MS and found nothing whatsoever. Is there a resource of documentation for these "undocumented" SP's?

Thanks,
Bill

>There's second output parameter, It's 1 if file exists and 0 otherwise.

DECLARE @file_exists int
>EXECUTE xp_fileexist 'C:\arcdbsql.log',
>	 @file_exists OUTPUT
>PRINT @file_exists

See also Message #692581.
>
>>Hi Sergey,
>>
>>Thanks and xp_fileexist is exactly what we want, but um, it's knid of the same as xp_cmdshell. In Query analyzer xp_fileexist returns a result set such as:

>>File Exists File is a Directory Parent Directory Exists
>>----------- ------------------- -----------------------
>>1           0                   1
>>
>>(1 row(s) affected)

>>However maybe I'm dense or something but I don't see the mechanism that allows you to access this result set after it's returned if xp_fileexist is executed in a SP.
>>
>>What am I missing here??
>>