xp_fileexists

[EM1107]

Good day Everyone!

I need your help and I hope that someone can help me!

I have a software that store the name of electronic documents and the path location in a database. I want to be able to use the database and verify if the document exists. I use xp_fileexists to do that. Up to that point it is fine. Where it get complicated is when the parrent directory and the document does not exist. I would like to be able to create the document and the directory path on the fly. Does anyone have a solution on that??

Thanks!

 

[mrdenny]

You can use xp_create_subdir to create folders. You wouldn't be able to create the document as you don't have the contents of the document.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[EM1107]

where can I get that extended procedure. It does not exist in my Sql Server 2000???

 

[mrdenny]

Sorry, I got that procedure from my SQL 2005 server. It doesn't appear that it's included in SQL 2000. In SQL 2000 it looks like xp_cmdshell will be your best bet.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com