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?
thanks.

---

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. 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.

---

http://www.dugger-it.com/articles/xp_fileexist.asp

---

]]>