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???
schmir1Asked:
Who is Participating?
 
Dishan FernandoConnect With a Mentor Software Engineer / DBACommented:
0
 
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
 
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
All Courses

From novice to tech pro — start learning today.