Running snapshot after schema update

Hi,
I want to know, if there is a schema change at the
publisher's side (done thru sp_repladdcolumn and/or
sp_addarticle etc), then the current snapshot becomes
invalid.
What's the best way to ensure that a fresh snapshot is
generated immediately?
I do not want to run the snapshot agent manually (or
schedule to run at a specific time). The requirement is
it should automatically as soon as there is a schema
change at Publisher. Is there any SP which I can call to
get this done?
regards
KP
Krishnaprasad,
you could create a wrapper stored procedure that calls both sp_repladdcolumn
and sp_start_job. When you need to add a column you call your wrapper rather
than the stored procedure directly.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)