Add/drop colum in repl DB | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Add/drop colum in repl DB

Hi..
I would like to know what would be happen if I just simply add/drop the column in repld db??? Or If I have added extra tables/column in production db do I need to do the same thing in repl db or do I need to rerun the snapshot agent?
You can use sp_repladdcolumn sp_repldropcolumn to add or drop columns to a previously replicated table. You can also modify this via the UI on the article properties page. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
If you add a new table to the publication, you will need rerun snapshot agent. WBR, Vlad A. Scherbinin
Rerun the snapshot but it does not replicate the new table.
Last action msg: A snapshot was not generated because no subscription needed the initialization
Hi,
please refer the following in order to drop / add column to replicated db : http://www.microsoft.com/sql/techinfo/tips/administration/addrepltablecolumns.mspx
http://www.mssqlserver.com/replication/bp_manual_replication_cleanup.asp
http://www.mssqlcity.com/Articles/Replic/troubleshooting_replication.htm Regards. hsGoswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

I wanted to know how do we replicate the new table from publisher to subscriber..
I know how to add/drop column…
so is there any way that i can replicate the new table without initialize the shema and data ?
]]>