Re: Trigger on commit

triggers only fire on INSERT/UPDATE/DELETE. If you cannot use one of these, say UPDATE, then the trigger cannot help you.

Any insert into another table (by the trigger) automatically becomes part of the "transaction" and it too will be COMITTED subsequent to any comit done as part of the transaction.

What you've described here seems somewhat awkward.

"Cristian Petculescu [MS]" <cristp_at_microsoft.com> wrote in message news:3c5ed41f$1_at_news.microsoft.com...
>
> I would like to get a trigger code fired when (after) a transaction that
> affects in any way a certain table is commited. I would like to use this
 to
> signal a client app that the table changed. I don't want to use triggers
 for
> insert/update/delete as these would have to insert in another table
 (because
> they will get commited when the other changes are commited) and becasuse
 in
> a transaction might be thousands of inserts and the only thing I care is
> when the table really changed to know it (not what the actual changes
 are).
>
> Is there support for such a thing?
>
> Thanks in advance,
> C
>
>
Received on Mon Feb 04 2002 - 22:21:17 CET