<div>
How can I delete them Vitor? &nbsp;I can't do it via Replication Monitor and they aren't showing in the Publications folder of Management Studio.
</div>


How can I delete them Vitor?  I can't do it via Replication Monitor and they aren't showing in the Publications folder of Management Studio.

<div>
Try:<br />

<pre><code id="code-20-40468839-1">exec sp_droppublication @publication = N'PublicationName'</code></pre>
</div>


Try:


exec sp_droppublication @publication = N'PublicationName'

<div>
Thanks.<br />
<br />
Ok, I this was unable to find any publications. &nbsp;In fact in the problem DBs the table syspublications system table does not exist.
</div>


Thanks.

Ok, I this was unable to find any publications.  In fact in the problem DBs the table syspublications system table does not exist.

<div>
You need to review the process you are using for deleting publications. Isn't a clear process for sure.
</div>


You need to review the process you are using for deleting publications. Isn't a clear process for sure.

<div>
Turns out the related DBs were restoring which I guess explains why they weren't appearing. &nbsp;Once the restores were complete I was able to log in and delete as you suggested.
</div>


Turns out the related DBs were restoring which I guess explains why they weren't appearing.  Once the restores were complete I was able to log in and delete as you suggested.

<div>
<div class="content wysiwyg-content">
We are having issues on our SQL Server 2008 server where more publications are showing up on our Replication monitor than what actually exist. &nbsp;Some of these are old jobs and some of them appear to be duplicates. &nbsp;Below is a screenshot of the Replication Monitor showing publications beside those shown in the Management Studio's Replication folder.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/11_w48/885250/replication.PNG" target="_blank" title="replication (27 KB)"><img alt="replication" class="file-block lazyload" style="max-width: 759px;" data-src="https://filedb.experts-exchange.com/incoming/2014/11_w48/885250/replication.PNG" /></a><br />
How can we resolve this issue?
</div>
</div>


replication.PNG

We are having issues on our SQL Server 2008 server where more publications are showing up on our Replication monitor than what actually exist.  Some of these are old jobs and some of them appear to be duplicates.  Below is a screenshot of the Replication Monitor showing publications beside those shown in the Management Studio's Replication folder.



How can we resolve this issue?

SQL 2008 Replication Monitor showing more publications than exist

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.