Sql Server 2005 replication monitor shows publication that has been deleted

SQL Server replication monitor shows publication that has been deleted\dropped.  How can I make this publication disappear from the Replication Monitor?
dfr031260Asked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
Here is what I have done in the past:
1. Create a dummy publication with the same name (just one article).
2. Now drop it.
0
 
Anthony PerkinsCommented:
Have you tried using sp_droppublication ?
0
 
dfr031260Author Commented:
exec sp_droppublication @publication='MergeRepl_scds_pro_test09'
GO

Failed:
Msg 14013, Level 16, State 1, Procedure sp_MSrepl_droppublication, Line 86
This database is not enabled for publication.

The publication is still in the replication monitor
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
Anthony PerkinsCommented:
What about sp_removedbreplication ?
0
 
dfr031260Author Commented:
Yes and I also tried:
exec sp_removedistpublisherdbreplication 'MergeRepl_scds_pro_test09','scds_pro

As you can see from the attached image, the publication is in the monitor, but there is nothing associated with it AND there is no publication associated with it either...SMH
ReplicationMonitorProblem-201204.JPG
0
 
dfr031260Author Commented:
Will try this right now...Get back to you in 15 minutes or less
0
 
dfr031260Author Commented:
NICE!!!! It worked
0
 
dfr031260Author Commented:
Nice work!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.