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 |
|
Guestuser18
Starting Member
34 Posts |
 Posted - 2009-11-03 : 10:41:37
|
| Hi GuysI'm running a procedure which exports a file to a folder. Do I need to give permission for that folder so I can export to it?Thanks in advance |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-03 : 11:05:10
|
| yes |
 |
|
|
Guestuser18
Starting Member
34 Posts |
Posted - 2009-11-03 : 11:07:56
|
| Do I give permission using sql or by going to the folder. Theres loads of info for this for oracle but none for sql server.Thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-03 : 11:17:30
|
| using windows file system. can right-click folder and go to permissions tab |
|
|
|
Guestuser18
Starting Member
34 Posts |
Posted - 2009-11-04 : 03:30:42
|
| But the thing is I'm logging onto a remote server to run the code. So if I want the code to output the file to my local folder on my harddrive, is that possible? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-04 : 12:47:19
|
| depending on how you're doing it...if server is in same domain and service account has permission to folder on your machine |
|
|
|
|
|
|
Permission to export to folder