sql server replication: Joe,
if you use sp_repladdcolumn and sp_repldropcolumn (or the replication editor) then the schema changes will be propagated on the next snapshot. Column changes are not permitted in SQL Server replication (yet). New stored procs etc won't be automatically added to a publication - you need to add them as new articles.
Regards,

I still confused with snapshot agents. What exactly does it do? If I
changed the structures of the tables in the database. And when snapshot
agent is schedule to run. Is it going to pick up the new table structures
and replicate the new table structures to subscribers??? And also if I add
new tables/views/stored procedures for publishing. Is snapshot agent going
to pick up the new published objects as well????

Hello Joe-
If you add the tables as an article as per the
documentation, then the subsequent execution of snapshot agent will pick up
the new tables for its propogation. That is true for column changes. Do
refer the books online for the steps to add the column and the tables to
the existing publication.

Regards,
Chandra


--------------------
||From: "Joe Mine" <huytuanattpgdotcomdotau>
||Subject: The roles of Snapshot agents..
||Date: Fri, 6 Feb 2004 12:00:52 +1100
||Lines: 8
||X-Priority: 3
||X-MSMail-Priority: Normal
||X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
||X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
||Message-ID: <#5#wsyE7DHA.4060@tk2msftngp13.phx.gbl>
||Newsgroups: microsoft.public.sqlserver.replication
||NNTP-Posting-Host: 220-244-64-102.tpgi.com.au 220.244.64.102
||Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.
phx.gbl
||Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.replication:47038
||X-Tomcat-NG: microsoft.public.sqlserver.replication
||
||I still confused with snapshot agents. What exactly does it do? If I
||changed the structures of the tables in the database. And when snapshot
||agent is schedule to run. Is it going to pick up the new table structures
||and replicate the new table structures to subscribers??? And also if I add
||new tables/views/stored procedures for publishing. Is snapshot agent going
||to pick up the new published objects as well????
||
||
||