Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Function and SP to find if file/directory exists Expand / Collapse
Author
Message
Posted Saturday, October 13, 2007 9:17 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 13, 2014 10:40 AM
Points: 573, Visits: 107
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
Post #410503
Posted Wednesday, July 7, 2010 9:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 10, 2012 4:18 PM
Points: 1, Visits: 13
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!
Post #948633
Posted Wednesday, October 27, 2010 4:55 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:39 AM
Points: 147, Visits: 539
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.



Post #1011947
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse