Hi Experts
–
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
Thanks,
Baddy