schmir1
asked on
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???
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???
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.
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.
No.....U can not drop the table if it is being replicated.
If you want to Drop table. You must delete the replication first.
If you want to Drop table. You must delete the replication first.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried deleting Jobs but that didn't help.
Thanks dishanf. I needed to do all steps then I could delete the tables.
Thanks dishanf. I needed to do all steps then I could delete the tables.
does this query return a row for your table ?
select * from sysarticles where name = <YourTable>
Can you post the result ?
Hilaire