Error 3724 : cannot drop table ...becuase it is published for ....

Dear helper,
I have a database that running on SQL Server 7 and it has been published for
replication for a period of time. After that period i remove the publication
and still the database running correctly without any problem.Then a change in
requirments happend, as a result i need to drop one table form the database.
When i tryed to drop the table an error show up says: "Error 3724: cannot
drop table "..." becuase it is published for replication
Paul,
I try this sp in SQL server 2000 that connect remotely with the database
running in sql server 7. Unfortunately SQLServer2000 could not find this sp
"Paul Ibison" wrote:

> Ayman,
> there is a stored procedure to do this called
> sp_MSunmarkreplinfo which takes a tablename as a
> parameter. Alternatively, setting replinfo to 0 in
> sysobjects for the particular table should do it.
> Finally, running sp_removedbreplication can be used to
> remove all traces of replication in the subscriber
> database.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||OK - I don't have a SQl Server 7.0 box here, but this
sounds feasible. In that case try one of the
alternatives - direct edit of the system table or
sp_removedbreplication with caveats mentioned before.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)