Monthly Archives: January 2007

How to check NOT FOR REPLICATION is enabled for a trigger

When creating a trigger, we can add NOT FOR REPLICATION to prevent chnaged data to be replicated to subscribers twice. In SQL Server 2005, in the view sys.triggers, the column is_not_for_replication tells you this information. However, in SQL Server 2000, … Continue reading

Posted in SQL server | Leave a comment