Function and SP to find if file/directory exists

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Simon Sabin » Function and SP to find if file/directory...

Function and SP to find if file/directory exists

Rate Topic

Display Mode

Topic Options

Author

Message

Simon Sabin

Posted Saturday, October 13, 2007 9:17 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:18 AM
Points: 573, Visits: 95

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

jeetv

Posted Wednesday, July 07, 2010 9:36 AM

Forum 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 Smile

Thanks!

Post #948633

Andy DBA

Posted Wednesday, October 27, 2010 4:55 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 8:16 AM
Points: 137, Visits: 441

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 »

Permissions