Hi all,
i think i found half of my answer.
if i make changes to tables or add tables, i need to use SP_AddArticle and SP_DropPArticle to add or drop the table from the publication..
if i have a large amount of changes on a source database, i guess it might be easier to drop the whole replication, blow away the subscription database and re-replicate it??
i'm still not sure about Stored Procedures, functions, views etc.
The environment I have is a stand by server. which contains a SQL server and application. If the main server dies for any reason i want a backup ready to roll.
Thanks
Dave