Thursday, February 16, 2012

Cannot get rid of syncobj_0Xblablabla

Hello,
We just decided here to stop using SQL Replication and move to
something more low-level for data redundancy (RAID replication)
But after using sp_removedbreplication on each replicated databases on
the server, I noticed that one of these databases kept its syncobj_0X
views, even if replications entries dont show up anymore in the
differents sections of the SQL Manager tree.
Any idea on how to remove these anoying views? I am using SQL Server
2000 on Windows 2000 Advanced Server
Thanks,
BTG
Manually issue drop view syncobj_0X statements.
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
<before.the.gods@.gmail.com> wrote in message
news:1134759647.255416.252810@.g49g2000cwa.googlegr oups.com...
> Hello,
> We just decided here to stop using SQL Replication and move to
> something more low-level for data redundancy (RAID replication)
> But after using sp_removedbreplication on each replicated databases on
> the server, I noticed that one of these databases kept its syncobj_0X
> views, even if replications entries dont show up anymore in the
> differents sections of the SQL Manager tree.
> Any idea on how to remove these anoying views? I am using SQL Server
> 2000 on Windows 2000 Advanced Server
> Thanks,
> BTG
>

No comments:

Post a Comment