Re: Fire triggers when reinitializing

Tech-Archive recommends: Speed Up your PC by fixing your registry

John,
I've never tested this, but presumably the initial load is a bulk insert
with FIRE_TRIGGERS set to false, that is assuming your triggers aren't
marked as NFR and there aren't any arguments on the snapshot or distribution
agents to control this setting. In this case you could try issuing
sp_addtabletocontents after the load, or use sp_addscriptexec to initiate
running the code that the trigger currently runs.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


.

Relevant Pages

  • Re: DTS - Triggers and Defaults Not Firing
    ... And that option is to uncheck "use fast load" ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > be updated via insert and update triggers. ...
    (microsoft.public.sqlserver.dts)
  • Re: New to SQL server
    ... it is called triggers. ... ANYTHING THAT YOU CAN DO IN JET IS BABY TALK COMPARED TO WHAT WE CAN DO ... anything that you can do in JET that I can't do in SQL Server ... self-referencing FKs and inline constraints. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access Form connected to SQL table in Access Data Project (.adp file)
    ... simply bad design to open up a form to a HUGE table, ... You can use what is called the "where" clause. ... the form what records it should load. ... we are NOT even using sql server yet. ...
    (microsoft.public.access.conversion)
  • Re: Profiling error message 208: sorting the wheat from the chaff
    ... Profile load to a file then load the> file to a table or have Proviler load to a table directly. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Access Form connected to SQL table in Access Data Project (.adp file)
    ... Under the previous design, he would just open the form and could ... navigate through the last few orders by clicking "next record" a few times. ... > the form what records it should load. ... we are NOT even using sql server yet. ...
    (microsoft.public.access.conversion)