Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

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

share|improve this answer
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
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. – Brandon Williams Oct 17 '12 at 20:25
The account used has permissions for everything. – Brian Oct 18 '12 at 12:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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