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)
 cannot drop the table

Author  Topic 

rushdib
Yak Posting Veteran

93 Posts

Posted - 2004-01-06 : 08:49:17
Hi,
We had to drop a table in a subscriber which was in a merge replication. We deleted the replication to drop the table, but it still says that table is in replication - cannot drop. The problem is with the subscriber. We were able to drop the table in the publisher. Can someone please help us?

Thank you,

Rushdi

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2004-01-06 : 10:18:21
See if this helps:
http://vyaskn.tripod.com/repl_ans3.htm#replinfo

--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page

rushdib
Yak Posting Veteran

93 Posts

Posted - 2004-01-06 : 10:55:11
Thank you so much, the first item in their suggestion worked.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-06 : 12:36:12
quote:
Originally posted by rushdib

the first item in their suggestion worked.



That'll be Vyas' own site. So "the first item in your suggestion worked".

Tara
Go to Top of Page
   

- Advertisement -