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 - 2003-07-02 : 07:38:30
|
| Kushal writes "Hi there, I want to get the list of files from a mapped drive using SQL Server SP (SQL Server 2K). I am using "master..xp_cmdshell('dir <MappedDriveName>'), but it doesn'rt work for mapped drive. It works good for the local drive. Any suggestions will be helpful.Thanks..Kushal" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-02 : 08:07:30
|
| Hi!The reason why it doesn't work is because you start the SQL Server Service with the LocalSystem account. You need to change that to a domain account which has access to the needed drives/resources. |
 |
|
|
|
|
|
Get a list of files