?
Solved

Cannot drop table after replication

Posted on 2003-10-30
8
Medium Priority
?
254 Views
Last Modified: 2010-08-05
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
Comment
Question by:bfeddish
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 17

Expert Comment

by:Tacobell777
ID: 9654369
Are you sure that you deleted the subscription on both sides?
0
 
LVL 1

Author Comment

by:bfeddish
ID: 9654381
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
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 9657407
which database system is this for?
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 1

Author Comment

by:bfeddish
ID: 9657452
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
 
LVL 13

Expert Comment

by:danblake
ID: 10640429
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 11113111
PAQed, with points refunded (500)

Computer101
E-E Admin
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question