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,
please try this:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl3_1mlq.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

[quoted text, click to view]


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

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)