SQL Server Performance Forum – Threads Archive
using xp_fileexsit problemusing 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. http://www.databasejournal.com/features/mssql/article.php/3686216 fyi). Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@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.