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

How to query master table in Query Analyzer?

In Enterprise Manager, I executed:
select id from sysindexes where (name ='customers')
and I've got the ID of the table.
In query analyzer, I executed:
use master; select id from sysindexes where (name ='customers')
and I don't have the value.
What is the right way to query the sysindexes from Query Anal?
Thanks.
light_wt wrote:
> In Enterprise Manager, I executed:
> select id from sysindexes where (name ='customers')
> and I've got the ID of the table.
> In query analyzer, I executed:
> use master; select id from sysindexes where (name ='customers')
> and I don't have the value.
> What is the right way to query the sysindexes from Query Anal?
> Thanks.
Sysindexes is a system table that resides in all databases. From QA use
the correct database first and then query sysindexes.
David G.
|||Thanks, David.
There is "use master;".
|||Which is exactly what you should remove.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"light_wt" <lightwt@.discussions.microsoft.com> wrote in message
news:FC3636CE-9987-4E38-8E32-230E78F85584@.microsoft.com...
> Thanks, David.
> There is "use master;".
|||light_wt wrote:
> Thanks, David.
> There is "use master;".
As Tibor said, remove that line. The Sysindexes you want to query is not
in the master database (unless you are installing user tables there).
Use the correct database first... which is not Master.
David G.