Hello,

I am looking for trigger which will copy a record to another database before erasing (I am confused about reference to another database inside trigger).

Can someone help me?

Thank you in advance

Jan

At this point of time(or atleast the last time I read the manuals!) you cannot use triggers to update a remote database table.
The alternative is to insert the deleted record into a local table and copy the records to the remote database table on a periodic basis, say, by means of a script or Replication.
HTH
Sathyaram