• I also used triggers once to separate out replication. We had a Sales database and an accounting database. We did this:

    Sales.dbo.SalesOrder table

    |-> trigger to insert into Sales.dbo.NewSales

    replication from Sales.dbo.NewSales to Accounting.dbo.NewSales

    Accounting.dbo.NewSales

    |-> trigger to add data to Accounting.dbo.SomeTable

    This was so if we had to drop replication, we wouldn't be moving all of the SalesOrder table, or interrupting operations.