• jeetv (7/7/2010)


    Hi Simon,

    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.