Hi Guys,

   I am trying to create an After Deleted Trigger that will copy the old record
into another database.

   e.g.  When a record is deleted from Database A, it is automatically inserted
into Database B.

   Something like the following..

      INSERT INTO B SELECT * FROM B__Old;

Any thoughts/suggestions?

Regards & TIA,

Ian

--

"Ian Branch" <branch@sitathome.net> wrote in message
news:9C410F80-E3CF-4854-BB21-87D158924594@news.elevatesoft.com...
> Hi Guys,
>
> I am trying to create an After Deleted Trigger

BeforeDelete. After delete it is gone.

Robert

Robert wrote:

>
> BeforeDelete. After delete it is gone.
>

So the INSERT syntax is correct?