|
|
Posted by Hilary Cotter on 09/13/07 18:37
you should be able to drop them using query analyzer.
--
RelevantNoise.com - dedicated to mining blogs for business intelligence.
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
"Query Builder" <querybuilder@gmail.com> wrote in message
news:1189702889.303360.189580@o80g2000hse.googlegroups.com...
> Hi,
>
> I have transactional replication set up on on of our MS SQL 2000 (SP4)
> Std Edition database server
>
> Because of an unfortunate scenario, I had to restore one of the
> publication databases. I scripted the replication module and dropped
> the publication first. Then did a full restore.
>
> When I try to set up the replication thru the script, it created the
> publication with the following error message
>
> Server: Msg 2714, Level 16, State 5, Procedure SYNC_FCR To
> GPRPTS_GL00100, Line 1
> There is already an object named 'SYNC_FCR To GPRPTS_GL00100' in the
> database.
>
> It seems the previous replication has set up these system views
> SYNC_FCR To GPRPTS_GL00100. And I have tried dropping the replication
> module again to see if it drops the views but it didn't.
>
> The replication fails with some wired error & complains about this
> views when I try to run the synch..
>
> I even tried running the sp_removedbreplication to drop the
> replication module, but the views do not seem to disappear.
>
> My question is how do I remove these system views or how do I make the
> replication work without using these views or create new views.. Why
> is this creating those system views in the first place?
>
> I would appreciate if anyone can help me fix this issue. Please feel
> free to let me know if any additional information or scripts needed.
>
> Thanks in advance..
>
> Regards,
> Aravin Rajendra.
>
Navigation:
[Reply to this message]
|