SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by iecdba / Getting Information if a file exists in SQL / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 07:32:12 GMT20RE: Getting Information if a file exists in SQLhttp://www.sqlservercentral.com/Forums/Topic406806-647-1.aspxThe following 2 files both exist on my c:\ drive: test.txt and config.sysWhen I use : EXEC master..xp_fileexist 'C:\CONFIG.SYS' I get the following results:File exists Files is a directory Parent Directory Exists1 0 1Which is what I would expect.However, when I use:EXEC master..xp_fileexist 'C:\TEST.TXT' I get the follwoing results: File exists Files is a directory Parent Directory Exists0 0 1Any help would be appreciatedThu, 24 Jan 2008 05:40:58 GMTtracey.harringtonGetting Information if a file exists in SQLhttp://www.sqlservercentral.com/Forums/Topic406806-647-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL+Aids/30424/">Getting Information if a file exists in SQL</A>[/B]Thu, 04 Oct 2007 08:12:08 GMTiecdba