<div>
Are you sure that you deleted the subscription on both sides?
</div>


Are you sure that you deleted the subscription on both sides?

<div>
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)
</div>


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)

<div>
which database system is this for?
</div>


<div>
It's for SQL Server 2000.<br />
<br />
I ended up dropping the publication alltogether on the publisher then the subscriber allowed me to delete the table.<br />
<br />

</div>


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.



<div>
You can run sp_addarticle and sp_droparticle on the replicated item involved without having to drop the entire publication.<br />
<br />
When a table is subscribed to replication a number of processes are not possible.<br />
<br />
check out:<br />
replinfo int Reserved. For use by replication. <br />
in the sysobjects table.<br />
<br />
If the replinfo &gt;&nbsp;0 then this object is being used within replication.<br />
<br />

</div>


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.



<div>
<div class="content wysiwyg-content">
I had a push subscription on server A that moved a table to server B. &nbsp;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. &nbsp;I am no longer using replication on it, how can I delete this table?
</div>
</div>


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?

Cannot drop table after replication

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.