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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Modifying tables being replicated

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
Go to Top of Page

dcarva
Posting Yak Master

140 Posts

Posted - 2004-01-12 : 16:25:24
Thanks for your help!
Go to Top of Page
   

- Advertisement -