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 |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2001-12-06 : 09:18:14
|
I am using SQL Server 7....If i have a database that is being transactionally replicated and i want to add a new field to one of the tables being replicated is there a way to remove only the table i want to add the field to - then add the new field - then put that table back into the replication. OR do i have to stop/restart the whole replication process just to add one new field to one of the tables ?I know you could do it in SQL 6.5 but it seems to have been removed in SQL 7 or am i missing something ?many thanksPaul |
|
|
Tim
Starting Member
392 Posts |
Posted - 2001-12-06 : 17:48:47
|
you are not missing anything :(you've got to drop the publication to do this, and that's a pain.SQL 2K will get yo uout of jail.-------------------------------Visit nr's cursor wonderland  |
 |
|
|
|
|
|
Adding a new field to a replicated table