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 |
|
jryannel
Starting Member
13 Posts |
 Posted - 2003-12-16 : 11:14:18
|
| I'm a very new to replication and I've set it up to perform transactional replication between to SQL DB's. On the Publisher I need to modify a table, but get the error message trying to save a change to one of my tables.Cannot drop the table 'mytable' because it is being used for replicationShort of dropping the publication is there anyway to modify the table and save the changes during replication?Thanks, Jeff |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-16 : 12:27:43
|
| No, you have to drop replication in order to modify the published table. To make it easy, script out the drop and create statements for replication by going to the publication, then right click and go to generate sql script.Tara |
 |
|
|
|
|
|
modifying a table during replication