Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-09-08 : 03:18:10
|
| Dear Experts,i've a teble with around 2000 rows, that is in replication(transactionsl). now i need to add two more columns to the same table. will it stops the replication? or any other problem?i've planned to do like this.open ssms, then go the tthe datbase and then table, right click, modify, then there add two columns then save. will this reflect at replacation server also?i'm using sql server 2005 ent editioni've heard that 2005 provides schema changes also for replication...ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-09-09 : 03:15:39
|
| we can directly do this. no need to worry. i've done this on test after successful completion at test, done at production. that was replicated at replication server also.ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
|
|
|
adding new columns to the replicated table