MS SQL Server - Testing existence of file

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Testing existence of file

cbrichards via SQLMonster.com

2006-03-27, 9:23 am

If I am only interested in testing for the existence of a file using:
master..xp_fileexist 'c:\windows\temp\rea
d.txt'

Is there any way to combine the above statement into a select statement to
return just the "file exists" value, or do I need to create a temp table and
perform an insert, then query against the temp table to just get the "file
exists" value?

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200603/1

Sponsored Links