От: | BlackEric | http://black-eric.lj.ru | |
Дата: | 02.06.22 07:14 | ||
Оценка: |
FR>CREATE TRIGGER tgr_ai_send_mail
FR> ON send_mail
FR> AFTER INSERT
FR>AS
FR>BEGIN
FR>declare @t varchar;
FR>declare @s varchar;
FR>declare @d VARCHAR(MAX) ;
FR>declare @m varchar;
FR>SELECT @t = (SELECT title FROM inserted)
FR>SELECT @s = (SELECT sender FROM inserted)
FR>SELECT @d = (SELECT Descr FROM inserted)
FR>SELECT @m = (SELECT Module FROM inserted)
FR>EXEC msdb.dbo.sp_send_dbmail
FR> @profile_name = N'adsf', --@t,
FR> @recipients = 's.polyakov@vconnect.ru', --@s,
FR> @body = N'zcvcxv',-- @d,
FR> @subject = N'zdgf',--@m,
FR> @body_format = 'HTML';
FR>END
FR>GO
FR>
FR>Microsoft OLE DB Provider for SQL Server ошибка '80040e14'
@recipients = 's.polyakov@vconnect.ru', --@s,
@body_format = 'HTML';
— вот тут N потерянаFR>declare @t varchar;
FR>declare @s varchar;
FR>declare @d VARCHAR(MAX) ;
FR>declare @m varchar;