how to check for file exists on the SQL server from a store procedure 2

[tbscmgi]

To All-
How can I check to see if a certain file exists on the SQL server from a store procedure.

I have a store procedure that create a file if number of row is > 0.

What I'm doing is schedule the store procedure to run from 6:00 AM thru 8:00 AM every 30 minute. I what it to only run if the file does not exists on the server.

Thank for any help.
Tony

 

[AlexCuse]

this ought to get you started:

http://www.nigelrivett.net/SQLTsql/CheckIfFileExists.html

Hope it helps,

Alex

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

[tbscmgi]

Alex-
Thank you very much.
Tony

 

[mrdenny]

I always recommend the xp_fileexists method. The other two methods are overkill as Microsoft has provided a stored procedure which can do the work from a single command.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[AlexCuse]

Denny - I was looking for that one the other day, but I was looking for sp_fileexists instead

Guess its' good to know I was not crazy (for thinking such a proc existed anyways)

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page