September 26, 2003 at 9:58 am
Hi,
I need some help with replication. I am new to DBA position in my company.We have replication betwwen 4 servers.we are getting the data into server 4 from servers 1,2 and 3.
we have the table Xxxx in all the 4 servers. Now we are going to add two columns to the table. basiacally i dont know which replication they are using already and which server is a publisher and which is subscriber,how should i know all the details.If i wanted to add the two columns what should i do with the existing replication? How can i do that in Enterprise Manager. please help me in this issue.
Thanks..
September 26, 2003 at 11:10 am
If it is SQL2K, you can add the columns using either sp_repladdcolumn, or via EM (its in the filter column tab of the publication properties). EM by default adds it to all publications.
If you have SQL7, you have to drop that table from any publication it exists in, make the change, then add it back. Then either snapshot, or be prepared to work harder to avoid the snapshot by propagating all the schema/proc changes manually.
Andy
September 29, 2003 at 8:06 am
Hi,
I have added a column to a table in the publication database using the Enterprise manager in my sql server 2000.But the column didn't affect in my subscription.Mean time I have reinitialized all of my subscriptions.Does it affect my replication?If it affects what should I do to get back my replication.
Thanks.
September 30, 2003 at 8:17 am
Can anyone help me in this issue?
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply