Hi  –

I want to insert/update/delete records into some other table a (say history table). & for this I'm using triggers

Firstly I tried instead of TRIGGER for insert, delete & update statements, as instead of triggers doesn’t support for the table having FOREIGN KEY with cascading DELETE or UPDATE

So i created After Trigger to captures these insert/update/delete statements, in after triggers, SQL Server does not allow text, ntext, or image column references in the inserted and deleted tables. As we are capturing the events (insert/update/delete) data from these two logical tables inserted and deleted.

As my table have BLOB (image, text, text) variables. I can't change the DB schema. I have to do something using Triggers…

But In both cases there is limitation i.e.

INSTEAD OF TRIGGER – doesn’t support table having cascading.

AFTER TRIGGER – doesn’t allow text, ntext, image column references in the inserted and deleted.

Any Suggestion Please…!

Thanks in advance,

Baddy