• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Cannot drop table after replication

I had a push subscription on server A that moved a table to server B.  I deleted the push subscription on A and it deleted but it failed delete the information off of server B. If I try to delete the table on server B it says it cannot delete it because it's being used for replication.  I am no longer using replication on it, how can I delete this table?
0
bfeddish
Asked:
bfeddish
1 Solution
 
Tacobell777Commented:
Are you sure that you deleted the subscription on both sides?
0
 
bfeddishAuthor Commented:
I have deleted the push subscription on server a. I can see the subscription still on the server b machine but there is no option do delete it. (Or do anything else for that matter)
0
 
LowfatspreadCommented:
which database system is this for?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
bfeddishAuthor Commented:
It's for SQL Server 2000.

I ended up dropping the publication alltogether on the publisher then the subscriber allowed me to delete the table.

0
 
danblakeCommented:
You can run sp_addarticle and sp_droparticle on the replicated item involved without having to drop the entire publication.

When a table is subscribed to replication a number of processes are not possible.

check out:
replinfo int Reserved. For use by replication.
in the sysobjects table.

If the replinfo > 0 then this object is being used within replication.

0
 
Computer101Commented:
PAQed, with points refunded (500)

Computer101
E-E Admin
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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