<div>
I would like to avoid schema changes if possible .. the database I am looking after is a third party db. 

</div>

<div>
this may help to show what I am doing. &nbsp;when I create it falls over saying I cannot use ntext text or image in a trigger. 
 
use [dbname] 
GO 
CREATE TRIGGER tr_InvitationBodyAlert 
ON ckbx_Invitation 
FOR UPDATE 
AS 
 
DECLARE @InvitBody_del varchar(max) 
DECLARE @InvitBody_ins varchar(max) 
DECLARE @InvitationID int 
DECLARE @body varchar(1000) 
 
select * 
into #ins_CkbxInvit 
from ckbx_Invitation 
where 1=0 
 
select * 
into #del_CkbxInvit 
from ckbx_Invitation 
where 1=0 
 
insert into #ins_CkbxInvit 
select top 1 * 
from inserted 
 
 
insert into #del_CkbxInvit 
select * 
from deleted 
where InvitationID = 
(select InvitationID from #ins_CkbxInvit) 
 
 
 
select @InvitBody_del = convert(varchar,body), 
@InvitationID = InvitationID 
from #del_ckbxInvit 
 
select @InvitBody_ins = convert(varchar,body) 
from #ins_ckbxInvit 
 
 
IF @InvitBody_ins &lt;&gt;&nbsp;@invitBody_del 
BEGIN 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set @body = 'The body of InvitationID = ' + convert(varchar, @InvitationID) + ' in the In dbname.ckbx_Invitation table has changed. Please notify Andrea or ' + suser_sname() &nbsp; 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;exec master..xp_sendmail 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@recipients = '&lt;my mail addr&gt;', 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@subject = 'Change Alert in checkbox', 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@message = @body 
END 
GO
</div>

<div>
david_32 said: 
&gt;&gt;this may help to show what I am doing. &nbsp;when I create it falls over saying I cannot use ntext text or image in a trigger. 
 
Right, that's why I suggested nvarchar(max). &nbsp;But if this is a 3rd party db, that might be risky.
</div>

<div>
<div class="content wysiwyg-content">
Hi Folks, 
 
I want an alert to trigger whenever the data in an ntext field (in a table) changes. An update trigger does no seem to work because the inserted and deleted views used in a trigger cannot be used so I cannot compare the diff between before and after the change. Is there any other way to do this? 

</div>
</div>

Hi Folks,

I want an alert to trigger whenever the data in an ntext field (in a table) changes. An update trigger does no seem to work because the inserted and deleted views used in a trigger cannot be used so I cannot compare the diff between before and after the change. Is there any other way to do this?


monitoring changes to an ntext field

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.