Quick script to find Published Articles in Transactional Replication

Quick script to list out all of your published articles for Transaction and Snapshot Replication in SQL Server 2005+. This is based on the dbo.sysextendedarticlesview view which unions together the dbo.sysarticles (articles) and dbo.sysschemaarticles (schema only based articles…no data is replicated for these objects) tables.

Primarily posting here because it took me a while to track this information down and maybe it’ll get picked up by search engines and save you some time someday.

1
2
3
4
5
6

SELECT seav.artid as [Article ID], 
           seav.name as [Article Name], 
           sp.name as [Publication Name]
FROM dbo.sysextendedarticlesview seav inner join
        dbo.syspublications sp on sp.pubid = seav.pubid
ORDER BY 2