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 |
|
dcarva
Posting Yak Master
140 Posts |
Posted - 2004-01-10 : 21:51:14
|
| Hello,I have a database that is set to replicate. I cannot make any changes to the table because replication is holding onto it. (such as removing the field's allow null flag) I tried stopping replication, but the table was still being held onto. Any suggestions?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-12 : 12:36:33
|
| You have to drop replication if you want to make schema changes. Script out the drop and create statements to make this easier on you.Tara |
 |
|
|
dcarva
Posting Yak Master
140 Posts |
Posted - 2004-01-12 : 16:25:24
|
| Thanks for your help! |
 |
|
|
|
|
|