sql server replication: Currently i have an article that publishes a stored proc. How can i change
its properties to publish the execution of the stored proc ? i.e. when the
sproc executes on the publisher, instead of propogating all the changes
affected by the sproc, i would like to invoke the execution of the same
sproc on the subsciber. Thanks

You could use sp_dropsubscription, sp_droparticle,
sp_addarticle with @type = 'proc exec',
sp_addsubscription and then run the snapshot agent and
synchronize.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)