Hi,
I have a simple procedure which saves my results in csv file:-
--exec sp_exportCSVData '##audit2','c:\audit2.csv'
exec sp_exportCSVData '##audit2','\\xxx.xxx.xxx\sglife$\ACTUARIAL\SH-ACTUARIAL\SQL Server\IFRS\audit2.csv','\\xxx.xxx.xx\sglife$\ACTUARIAL\SH-ACTUARIAL\SQL Server\IFRS\'
When I login to a remote desktop using my windows id , I am not able to generate this file but no errors in SQL Server script execution.
When I login to Database Server with same login id (windows AD account), I am able to generate the file in this shared folder.
Please assist.
0
Account has read / write permission.
Case 1
Login into Desktop è Remote to SQL Server (Database Server / (using own User ID)) è SQL program (using own User ID)
The results can be generated to the actuarial shared drive
Case 2
Login into Desktop è SQL program locally using SSMS client (using own User ID)
Results not found in the actuarial shared drive thought no error is prompted.
Thanks
Namit Sehgal