I am using Transactional Replication with SQL 2000.
I have selected a few Stored Procedures as articles. I am using the
'Replicate the schema only' option as I do not need the execution to be
replicated at the subscriber.
The Stored Procedures schema is being replicated without problem after I run
the Snapshot, LogReader and Dsitribution agents.
My questions are:
I need to change the Stored Procedure definition, should that get replicated
automatically without the need of running the snapshot again?
Is there any way of updating the Stored Procedures definition at the
subscriber without having to re-run the Snapshot?
Thank you for your help