Creating a Non-Replicating Trigger on a Replicated Table

• efjspencer

  SSC Veteran

  Points: 265

  More actions

  October 30, 2009 at 5:35 am

  #211576

  Happy Friday Team.

  Anyways, I've got a trigger sitting on a table that fires on Insert, Delete or Update. The trigger then calls into a stored procedure on a separate database (Data Warehouse).

  This works fine on my central database, but the problem is that it is being replicated down to my subscribers, where the Data Warehouse database doesn't exist - so was naturally causing errors.

  I've removed the trigger for now, but does anybody know of a way of setting a trigger to be non-replicated?

  (I have done a web search - but "replication" and "trigger" aren't great things to search for)

  Thanks in advance.

  Ted, London.

• peterhe

  SSChampion

  Points: 11469

  More actions

  October 30, 2009 at 6:57 am

  #1073075

  CREATE TRIGGER YourTrigger ON YourTable

  FOR INSERT

  NOT FOR REPLICATION

  AS

  .....

• efjspencer

  SSC Veteran

  Points: 265

  More actions

  October 30, 2009 at 7:20 am

  #1073098

  Merci!