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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-17 : 07:44:42
|
| Chris Burns writes "I have 3 SQL Servers1 PDC2 standalones that are members of the domain.3 need to replicate transactional data fro 2 standalones to DB's on the PDC4 I do all of my upgrades (table changes, Sprocedures) via query analyzerI get error messages stating that this database has been marked for replication and cannot change tables?Any thoughts because both processes have to occur.Thanks" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-17 : 12:26:14
|
| You need to drop replication in order to change your tables. After your table changes have been made, you can recreate replication. To easily do this, just script out the drop and create statements in EM. Go to the publication and right click on it and go to generate script.Tara |
 |
|
|
|
|
|
Replication