2

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.

1 Answer 1

1

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

6
  • 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
    Commented Oct 17, 2012 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
    Commented Oct 17, 2012 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
    Commented Oct 17, 2012 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. Commented Oct 17, 2012 at 20:25
  • The account used has permissions for everything.
    – Brian
    Commented Oct 18, 2012 at 12:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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