От: | Funny Rabbit | ||
Дата: | 02.06.22 06:28 | ||
Оценка: |
CREATE TRIGGER tgr_ai_send_mail
ON send_mail
AFTER INSERT
AS
BEGIN
declare @t varchar;
declare @s varchar;
declare @d VARCHAR(MAX) ;
declare @m varchar;
SELECT @t = (SELECT title FROM inserted)
SELECT @s = (SELECT sender FROM inserted)
SELECT @d = (SELECT Descr FROM inserted)
SELECT @m = (SELECT Module FROM inserted)
EXEC msdb.dbo.sp_send_dbmail
@profile_name = N'adsf', --@t,
@recipients = 's.polyakov@vconnect.ru', --@s,
@body = N'zcvcxv',-- @d,
@subject = N'zdgf',--@m,
@body_format = 'HTML';
END
GO
Microsoft OLE DB Provider for SQL Server ошибка '80040e14'