xp_fileexist appears to require sysadmin permissions.
If I run this with sysadmin
exec xp_fileexist '\\servername\appfolder\filename.txt'
I get File Exist with a 1
However, when sysadmin permissions are removed it returns File Exists with a 0.
Does anyone know of any other way to grant the permission to return the correct result.