Dear All,
Hi! I need a MS-SQL QUERY based solution (without using xp_CmdShell) to check that given file name (for ex.: - 123.jpg) is exists on connected Server under specified path or not.
For example: -
I am connected with a Web application Database server in Management studio. This server has 4 drives (C, D, E, F). In F drive there is a folder by the name "TEST".
Now I need a QUERY (without using xp_CmdShell) by which I can check that "123.jpg" file is exists in this "TEST" folder or not.
If possible, kindly solve this issue.