Hi
I have a delete trigger which needs to insert data (for archiive purpose) from deleted table . here is the code :
create trigger td_member_message on member_message
after delete
as

begin
declare @numrows int,
@errno int,
@errmsg varchar(255),
@now datetime

select @numrows = @@rowcount, @now = getdate()

if @numrows = 0
return

insert member_message_arch
select d.*, @now
from deleted d

return

/* Errors handling */
error:
raiserror @errno @errmsg
rollback transaction
end
go

But I am getting error here like:
Msg 311, Level 16, State 1, Procedure td_member_message, Line 20
Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.

I know using of instead of trigger can get rid of this error but I cannot think of using instead of trigger in this case.

CAn anyone pls help me?
Thanks in advance