SQL Server Performance Forum – Threads Archive

Alter replicated stored procedure?

Folks, 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… Beuller?

Have you tried with ALTER PROCEDURE in this case? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Sure have and it doesn’t replicate the change…

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
***********************

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…<sigh&gt<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />.<br /><br />

]]>