Stored Procedure To See If A File Exists 1

[webuser]

I know I saw some place a Stored Procedure (It may have been an undocumented one) to find out if a specific file name exists. I guess a documeneted Sproc would be preferable but I'll take anything at this point.

Thanks in advance!!!

 

[tlbroadbent]

There is an "undocmented" extended stored procedure named xp_fileexist. The XP syntax is as follows.

Declare @rc int

Exec master.dbo.xp_fileexist
"\\Server\data\Filename.txt",@rc Output

If @rc=1
Print 'Exists'
Else
Print 'Does not exist'

Get more info on "undocmented" extended stored procedures at the following link.

http://www.swynk.com/friends/achigrik/SQL70ExtSP.asp

See my SQL Articles page for more links, including "Undocumented Stored Procedures" and "Undocumented DBCC Commands"

http://tlbroadbent.home.attbi.com/sqlarticles.htm

Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[webuser]

Perfect. Thanks!