SQL Server Performance

using xp_fileexsit problem

Discussion in 'SQL Server 2005 General Developer Questions' started by comiccrazy, Jul 24, 2007.

  1. comiccrazy New Member

    using xp_fileexsit problem

    hi guys,
    I have a problem here.
    when i use xp_fileexsit with specific location , it give me 0, 0, 0
    but the file physically locate there.
    when i using 'c:oot.ini', everything works fine, give me 1 ,0,1
    what is the problem?
    thanks.
    comiccrazy, Jul 24, 2007
    #2

  2. Chappy New Member

    Make sure <the account which sql server is running as> has read permissions on the file and location

    If the file is on a network, the sql server must be running as a domain user and not a local one
    Chappy, Jul 24, 2007
    #2

  3. satya Moderator

    I believe this may not work in future versions of SQL, why not use POWERSHELL in this case to make use of such requirement. http://www.databasejournal.com/features/mssql/article.php/3686216 fyi).

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
    satya, Jul 25, 2007
    #2

  4. dineshasanka Moderator

    dineshasanka, Aug 1, 2007
    #3

Share This Page