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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 permission acess the share folder.

Author  Topic 

angel777
Starting Member

2 Posts

Posted - 2008-06-22 : 22:29:39
hi. i got a question regarding the permission on share folder.
i wonder i am able to do this as below..
if on runtime, after i export the data to xmlfile and i want it to auto save into the SHARE Folder in sql server. can i do that ?

** after press a button, auto export data to xml file, then auto save the xml file to share folder.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-22 : 22:37:00
Is share folder on local disk of sql server? If not, have to start sql service with domain account that has proper permission.
Go to Top of Page

angel777
Starting Member

2 Posts

Posted - 2008-06-23 : 01:57:11
the share folder is on the local disk..
can u provide some info on how to configure the share folder so that it is able to be accessible written by all ...security issue..
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-23 : 23:10:28
Then you can save file to any folder, and you can dump data with bcp or data export wizard.
Go to Top of Page
   

- Advertisement -