[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 543
  • Last Modified:

Deleting Replicated tables

I'm getting the following error message when I try to delete a table:
  Error 3724: Cannot drop the table 'dbo.Raw_Test_Data' because it is being used for replication.
                                                                                               
The table use to be on the subscriber's side of a replication.  I deleted the replication on the distributor server but still can't delete these tables???
0
schmir1
Asked:
schmir1
1 Solution
 
HilaireCommented:
Hi,
does this query return a row for your table ?

select * from sysarticles where name = <YourTable>
Can you post the result ?

Hilaire
0
 
frodomanCommented:
In addition to deleting the publication, you must also delete any jobs associated with the replication.  Usually this is only the snapshot agent which runs (unless you changed the default) once a week.

I don't have it in front of me, but in Enterprise Mgr I believe you'll find the job under Management -> Jobs.  Delete the snapshot agent for this replication and then you should be able to drop the table.
0
 
Dishan FernandoSoftware Engineer / DBACommented:
No.....U can not drop the table if it is being replicated.

If you want to Drop table. You must delete the replication first.
0
 
Dishan FernandoSoftware Engineer / DBACommented:
0
 
schmir1Author Commented:
I tried deleting Jobs but that didn't help.

Thanks dishanf.  I needed to do all steps then I could delete the tables.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now