Replication Objects are still there.....

I restored a db to a new server, executed the following;
exec sp_removedbreplication 'ADAGE'
go
exec sp_dboption 'ADAGE', 'published', 'FALSE'
go
exec sp_dboption 'ADAGE', 'merge publish', 'FALSE'
go
Yet, the ADAGE db still has views like sync%
Did I miss a step necessary to remove all traces of replication on this db?
Do I have to manually remove these objects?
I want to use this database to replicate to (New Publication / Subscription), but I first want to make sure all traces of previous replication are gone.
JLS
you missed the manual delete step. But you really don't have to do this. When you reinstall replication or recreate a publication it will whack the objects it doesn't need anymore or create new names.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23DNr6Nk2FHA.2816@.tk2msftngp13.phx.gbl...
I restored a db to a new server, executed the following;
exec sp_removedbreplication 'ADAGE'
go
exec sp_dboption 'ADAGE', 'published', 'FALSE'
go
exec sp_dboption 'ADAGE', 'merge publish', 'FALSE'
go
Yet, the ADAGE db still has views like sync%
Did I miss a step necessary to remove all traces of replication on this db?
Do I have to manually remove these objects?
I want to use this database to replicate to (New Publication / Subscription), but I first want to make sure all traces of previous replication are gone.
JLS
|||Ok, great, Thanx!!!!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:%234Jhehk2FHA.3416@.tk2msftngp13.phx.gbl...
you missed the manual delete step. But you really don't have to do this. When you reinstall replication or recreate a publication it will whack the objects it doesn't need anymore or create new names.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23DNr6Nk2FHA.2816@.tk2msftngp13.phx.gbl...
I restored a db to a new server, executed the following;
exec sp_removedbreplication 'ADAGE'
go
exec sp_dboption 'ADAGE', 'published', 'FALSE'
go
exec sp_dboption 'ADAGE', 'merge publish', 'FALSE'
go
Yet, the ADAGE db still has views like sync%
Did I miss a step necessary to remove all traces of replication on this db?
Do I have to manually remove these objects?
I want to use this database to replicate to (New Publication / Subscription), but I first want to make sure all traces of previous replication are gone.
JLS