I am using "master..xp_getfiledetails @path" method to get file details.
I am not sure, maybe the @path must in this format "C:\TestFolder\SubFolder\TestFile.pdf" only can work, because i get error of "xp_getfiledetails() returned error 3, 'The system cannot find the path specified.'".
So if it is true, the @path i have now is in this format : "../../../../../TestFolder/SubFolder/TestFile.pdf".
Anyone could tell is there any way i can map the path including which drive the file is located?