Post reply

Function and SP to find if file/directory exists

  • October 13, 2007 at 9:17 pm

    #199036

    Comments posted to this topic are about the item Function and SP to find if file/directory exists


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

  • July 7, 2010 at 9:37 am

    #1189693

    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".

    I was wondering how this could be updated to run in SQL Server 2005...I am not a DBA myself:-)

    Thanks!

  • October 27, 2010 at 4:55 pm

    #1243241

    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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply