Getting Information if a file exists in SQL

• iecdba

  SSC-Addicted

  Points: 424

  More actions

  October 4, 2007 at 8:12 am

  #178008

  Comments posted to this topic are about the item Getting Information if a file exists in SQL

• tracey.harrington

  Grasshopper

  Points: 23

  More actions

  January 24, 2008 at 5:40 am

  #771222

  The following 2 files both exist on my c:\ drive:

  test.txt and config.sys

  When I use :

  EXEC master..xp_fileexist 'C:\CONFIG.SYS'

  I get the following results:

  File exists Files is a directory Parent Directory Exists

  1 0 1

  Which 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 Exists

  0 0 1

  Any help would be appreciated