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.


Yes, you can use the system stored procedure sp_addscriptexec to run an ad-hoc script on all the subscribers.

  • Thank you for you help but unfortunately this does not work in my case. Merge-Replication is currently at SQL 2000 level and when I tried this it did not work.
    – Brian
    Oct 17 '12 at 17:45
  • @Brian: The article I linked to says it should work on SQL 2000 subscribers. Are you getting an error message?
    – Jon Seigel
    Oct 17 '12 at 18:22
  • The error I am recieving is: The schema script '0020_Script01.sql' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) Get help: help/MSSQL_REPL-2147201001
    – Brian
    Oct 17 '12 at 19:16
  • 1
    Please ensure the SQL Server service account has read and write permissions on the snapshot folder and read permissions on the location where the script is stored. Oct 17 '12 at 20:25
  • The account used has permissions for everything.
    – Brian
    Oct 18 '12 at 12:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.