I tried using this nice code in SQL Server 2005 but it fails with the message "Only functions and extended stored procedures can be executed from within a function".
Same question: Is there a way to check file existence from a function? I have a table containing filenames and wish to perform a set based query to list missing files.
I really hope I don't have to resort to using a cursor loop for this!
Thanks in advance.