How to remove replication objects from a restored database?

Hi,
I've restored a database that had replication on it to a different server
without replication. How can I remove the replication objects from this
database?
I've googled and found nothing so far...
Regards
paul
Paul,
please try this:
http://msdn.microsoft.com/library/de...repl3_1mlq.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||On Fri, 17 Feb 2006 17:11:33 -0000, Paul Ibison wrote:

> Paul,
> please try this:
> http://msdn.microsoft.com/library/de...repl3_1mlq.asp
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
Cheers Paul, but I'd tried that one - which doesn't remove the objects for
me.
I have SPs of the name of FLTR_ etc... that are still there, as well as
views SYNC_
This database was a replication source on the orginal server, not a
subscriber database.
|||Paul,
this proc is the best we have out of the box. Hilary has a script he has
posted up a few times to remove orphaned records, or you could knock one
together yourself - either way you'll need a customised solution.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql