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 |
|
nishithrn
Yak Posting Veteran
58 Posts |
 Posted - 2002-08-18 : 08:00:41
|
| Hello,I have got a replication job(Transactional), which is working fine. However, it is not allowing me to modify the structure of the existing table on the publisher which is used for replication. Is there a way in which I can breake the replication, change the table structure and again re-set the raplication back to its original state.Regards |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-08-19 : 01:36:43
|
| Which SQL Server you are using? 2000 or 7?If using sql server 7 , then you have to drop the whole replication,make changes in the table definition and then again create it.If you are using SQL server 2000, then you can drop that perticular table from the replication and can make changes and can again add for publication.---------------------------Sandesh - The Messanger |
 |
|
|
|
|
|
Replication !!!