Hi:

You can disbale the publication for database by using
exec sp_replicationdboption 'Northwind','publish','false'. This also
removes all the publications for this database from the
replication/publications folder. Before doing this, I also scripted all the
publications.

To publish back again, I used
exec sp_replicationdboption 'Northwind','publish','true'.
To recreate the pubications for this database, I used the script.

After doing that, I noticed that data is not being replicated. Status for
snapshot agent says that it has never run. Doesn't the script starts the
agents automatically? Do you have to start the agents manually? Do I need
to synchronize something manually?

Please let me know.

Thanks

Souhail,
remember the agents are run as jobs, so just set the scheduled of the agents
as you would do normally. For transactional and merge, this typically
involves running the snapshot agent manually during initialization and not
on a schedule (different if you have anonymous subscribers). After that you
set an appropriately frequent schedule for the distribution/merge agent.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)