"John Hård" <John Hård@discussions.microsoft.com> wrote in message
news:3FDB105D-7D3A-466C-8A09-4646277D6FF4@microsoft.com...
> Hello,
>
> I have a transactional replication set up and I want a trigger on the
> destination table to fire on all every row when I reinitialize the
> replication. How do I make this happen? Right now the trigger won't fire
> during the initial load of data, but after that it works fine.
> Is there a setting somewhere?
>
> I am using SQL server 2005 on both the subscriber and publisher.
>
> Thanks,
>

"Raymond Mak [MSFT]" wrote:

> Hi John, the setting to enable firing of triggers during the initial bulk
> load is not exposed in SSMS, but it is configurable through the
> @fire_triggers_on_snapshot parameter in sp_addarticle and the
> 'fire_triggers_on_snapshot' property through sp_change_article.
>
> -Raymond
>
> "John HÃ¥rd" <John HÃ¥rd@discussions.microsoft.com> wrote in message
> news:3FDB105D-7D3A-466C-8A09-4646277D6FF4@microsoft.com...
> > Hello,
> >
> > I have a transactional replication set up and I want a trigger on the
> > destination table to fire on all every row when I reinitialize the
> > replication. How do I make this happen? Right now the trigger won't fire
> > during the initial load of data, but after that it works fine.
> > Is there a setting somewhere?
> >
> > I am using SQL server 2005 on both the subscriber and publisher.
> >
> > Thanks,
> >
>
>