SQL Server Performance

Alter replicated stored procedure?

Discussion in 'Performance Tuning for SQL Server Replication' started by Haywood, Dec 6, 2006.

  1. Haywood New Member


    Does anyone have any suggestions on how to ALTER a replicated stored procedure? I can create a new procedure, add it to the publication (& subscriber(s)) and it works fine.

    However, I cannot find anything on altering an existing replicated procedure. sp_changearticle I can't seem to get working, nor sp_reinitsubscription; both of which allow me to manipulate article/publication/subscription and indicate that I should be able to alter the procedure and push that to the subscriber...

  2. satya Moderator

    Have you tried with ALTER PROCEDURE in this case?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. Haywood New Member

    Sure have and it doesn't replicate the change...
  4. ndinakar Member

    Are you publishing the stored procs too? If not you'd have to manually recompile the proc on the subscriber.

    Dinakar Nethi
    SQL Server MVP
  5. Haywood New Member

    Yes, we're publishing the procedures too... IIRC, when I took my replication class eons ago I seem to remember replicating procedures and it working. Could be an issue with my specific install and SP level (I inherited this system...&lt;sigh&gt<img src='/community/emoticons/emotion-5.gif' alt=';)' />.<br /><br />

Share This Page