ALTER PROCEDURE [dbo].[send_dbmail_attachment]
 @recipients                 VARCHAR(MAX)  = NULL, 
   @subject                    NVARCHAR(255) = NULL,
   @body                       NVARCHAR(MAX) = NULL, 
   @body_format                VARCHAR(20)   = NULL, 
   @file_attachments           NVARCHAR(MAX) = NULL
    
WITH execute as self
AS
BEGIN
	SET NOCOUNT ON;


EXEC msdb.dbo.sp_send_dbmail  @profile_name = 'SQL01',
                          @recipients = @recipients,
                          @body_format = @body_format,
                          @body = @body,
                          @subject = @subject,
                          @File_attachments = @file_attachments
END

declare @Mail varchar(100) = 'amanat_2007@mail.ru'
,@MessageMAIL varchar(100) = 'wewewew'
,@Subject varchar(100) = 'wewewewe' 
--,@File_attachments varchar (1000) = '\\10.0.0.1\12\0a69044e-1c2e-11e6-badd-005056a00106_cf2b79bc-4af2-4bc7-b194-a35de9644b25.jpg'
,@File_attachments varchar (1000) = 'wefcw'
,@ID_Request bigint 
,@CashID int
,@ID_Type_Processing int = 11
,@keyboard_parameter varchar(1000)
, @keyboard_id int
,@AddDate datetime = getdate()
,@i int
BEGIN TRY

	EXEC @i = msdb.dbo.send_dbmail_attachment  
		  @recipients = @Mail,
		  @body_format = 'HTML' ,
		  @body = @MessageMAIL,
		  @subject = @Subject,
		  @File_attachments = @File_attachments
	select ERROR_MESSAGE()
	select @@ERROR
	insert into SMS_REPL..VideoPhotoOrderSEND_mail_log (date_add
	                                                   ,ID_Type_Processing,mail,body,subject
													   ,File_attachments,par1,ID_Request
													   ,keyboard_id, keyboard_parameter)
	select @AddDate, @ID_Type_Processing, @Mail, @messageMAIL, @Subject, @File_attachments
		  ,case when @ID_Type_Processing = 9 then @CashID else null end, @ID_Request
		  ,@keyboard_id, @keyboard_parameter
END TRY
BEGIN CATCH
	insert into SMS_REPL..VideoPhotoOrderSEND_mail_log (date_add
	                                                   ,ID_Type_Processing,mail,body,subject
													   ,File_attachments,par1,isErr,ID_Request
													   ,keyboard_id, keyboard_parameter)
	select @AddDate, @ID_Type_Processing, @Mail, @messageMAIL, @Subject, @File_attachments
		  ,case when @ID_Type_Processing = 9 then @CashID else null end, 1, @ID_Request
		  ,@keyboard_id, @keyboard_parameter																		   
END CATCH					

Сообщение 22051, уровень 16, состояние 1, строка 0
Недопустимый файл вложения wefcw.