@ATTACHMENT PROBLEM FOR SHARED FOLDERS

Question

HI I M SENDING A MAIL WITH AN ATTACHMENT WHOSE LOCATION FORMAT IS SHOWN BELOW

set @attachment='\\10.6.10.10\D$\bills\B002ABTS_KAC_560005_13890771_974015604_80.ps.pdf' THIS WORKS PERFECTLY!
BUT I DONT WANT TO INCLUDE 'D$'
SO I SHARED THE FOLDER  AND CHANGED FORMAT AS SHOWN BELOW


 

 set

 

 

 

@attachment='\\10.6.10.10\bills\B002ABTS_KAC_560005_13890771_974015604_80.ps.pdf'


BUT ITS GIVING ERROR AS " INVALID"

 

Answer 1

HI Sir,
can you check that you can see the path using the account under which SQL server is running.
By the way how you send emails using sp_send_dbmail or other way (custom script  etc..)

Ivan

Answer 2

HI Sir,
can you check that you can see the path using the account under which SQL server is running.
By the way how you send emails using sp_send_dbmail or other way (custom script  etc..)

Ivan

i am using sp_send_dbmail , i want to execute the code inside a stored procedure

Answer 3

I suppose SQL server account do not have rights over the share you created,
this is the reason I am asking you to verify this.

Ivan