Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Select query to check filexists is it possible

Author  Topic 

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2010-03-08 : 13:43:02
I would like to use the following select query to check wether the fileexists or not:

EXEC Master.dbo.xp_fileexist @filepath,@File_Exists OUT

select filedownloadid,filepath from tab_ccsNetEmailFilesInfo

can you please help, how to use the exec xp_fileexist to check against filepath, this file has the filepath to file.

Thank you very much for the helpful info.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-03-08 : 13:46:14
Look here for example:
http://www.sqlservercentral.com/Forums/Topic360785-9-1.aspx#bm360825


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -