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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-15 : 08:25:16
|
| Johnny writes "Hi there,Hope all is well with you all.I was wondering if there is some sort of a Stored Procedure that could allow access to the File System, such as:1. execute [sp][xp]_get_files_list @directory='C'2. execute [sp][xp]_does_file_exist @directory='C', @filepath='C:\temp\text.txt'Or is there any way to access the File System by any means and retreive such results?Thanks in advance!-Johnny" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-09-15 : 08:46:19
|
| have a look at "xp_cmdshell"...with exec xp_chdshell 'Dir C: >a.txt' being an examplexp_cmdshell is however a extended SP, which has security implications....search here for examples/more info |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-09-15 : 09:29:00
|
| check out:xp_dirtree, xp_fileexistrockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
|
|
|
|
|
|
File System stored procedures