var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Checking existence of network file
Just wonder if anyone know how can I check the network file (whether exists or not) using TSQL or Extended Stored Procedures?
What I can find out is the xp_fileexist, but it is only meant for searching file residing locally... I have tried mapping the drive of another server to the SQL server, but it just won't do it...
Thanks in advance.
I have used xp_cmdshell as follows:
exec @result = xp_cmdshell ('dir \\server\share\filename.ext')
if(@result = 0)
it's there so do something
This has worked well so far...