Getting Information if a file exists in SQL

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

  • 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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply