ALTER TRIGGER [dbo].[NewCustomer]

ON [dbo].[YKUN4015]

FOR INSERT,UPDATE

AS

declare @INTNR varchar(10) 
declare @Name1 varchar(50)
declare @message varchar(500)

declare @query_attachment_filename nvarchar(255)
declare @file_attachments nvarchar(max)

SET @INTNR =(SELECT INTNR FROM inserted)
SET @Name1 =(SELECT Name1 FROM inserted)
SET @message='New Customer with Number '+@INTNR+' and name '+@Name1+''

EXEC msdb..sp_send_dbmail 

            @recipients = 'mymail@mail.com',

            @subject = 'New Customer in DB',

			@body = @message,

			@file_attachments = 'J:\testdatei.txt';

• could this be a security issue, does whatever this is running under have rights to J:
  
• Is there a file called testdatei.txt in J:
  
• Have you tried UNC Pacth \\Server\testdatei.txt