var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: List the folder contents using SQL
I have built a Disaster Recovery Site for my DB.on periodic basis, trn files from production server reach DR server and DR setup will apply them locally.
If the flow is smooth then no issues, if one of the file does not reach DR
the entire setup will halt for the want of the file and I dn't have any means to
know which file is missing.
Both my production and DR site located remotely behind firewalls, i.e i can't
physically access the servers or remotely login to the server.
Can anyone tell me how to see the contents in a folder in the server using
SQL query .
Any help is highly appreciated
Thanks and Regards
I'd use xp_cmdshell.
master..xp_cmdshell 'dir c:\'
Harshal, sorry to find "STUPID" as Ur Signature
Last edited by vrsrinivas; 06-15-04 at 04:28.