I have a SQL Server 2005 publisher with SQL Server 2005 subscribers and one SQL Server 2000 subscriber running merge replication.
Is there any way to modify triggers at a subscriber with the replicating schema changes set to false (replicate_ddl = 0
) without reinitializing the whole publication?
A solution where the triggers are only modified on the SQL Server 2005 databases is fine.