January 29, 2007 at 9:07 am
Hello,
I am making some API calls from a workstation to be able to build a tree with the directory structure (drives) on the sql server. Does anybody know any calls that can be made in SQL or API that will validate a directory path (on the sql server)?
Thank you
January 29, 2007 at 9:14 am
there are several scripts in the scripts section that do this:
i searched "directory exists"
Verify Directory Exists and Create if Necessary
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1463
therre are several others as well:
| Scripts | Rating | Search Score |
| Verify Directory Exists and Create if Necessary | 3.8 | 100 |
| Getting Information if a file exists in SQL | 3.25 | 99.54 |
| Function and SP to find if file/directory exists | 2.83 | 99.08 |
| Backup all Databases Using SQL LiteSpeed | 3.86 | 98.62 |
| Import databases using backups | 5 | 98.62 |
| Import databases using backups v 2 | 3 | 98.62 |
| Backup any/all Databases (Native AND LiteSpeed friendly) | 4.88 | 98.62 |
Lowell
January 29, 2007 at 9:48 am
Thank you for your quick answer... This will certainly be useful in the future.
One of the guys here at work was working with the undocumented extended stored procedures, we were using xp_dirtree to generate the directory tree to build for prompting, and one other xp_ call is xp_fileexist, which from his tests, also will validate the directory... nothing like trying to get things finished for a deadline..
Again, thank you for your help. Very helpful.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply