Steve Troxell wrote:
>Prior to today, I've done nothing with mirroring. Two of us have
>independently setup a mirroring scenario with triggers in the principal and
>mirror databases. The triggers write to a separate, non-mirrored database
>(identical copies on the principal server and the mirror server).
>
>In both cases the triggers will fire in the principal database, but not in
>the mirror database. Is this expected behavior for mirroring? It doesn't seem
>to matter whether the NOT FOR REPLICATION option is on the trigger or not.
>
>I scoured the documentation and the internet but could find no reference to
>this. So I have to wonder if we're just missing something.
>
>Steve Troxell