using xp_fileexsit problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

using xp_fileexsit problem

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?

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
I believe this may not work in future versions of SQL, why not use POWERSHELL in this case to make use of such requirement. fyi). Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@ 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.