Finding Published articles in the database of SQL Server
USE Distribution
GO
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
-- Get the publication name based on article --
SELECT DISTINCT srv.srvname publication_server , a.publisher_db ,USE Distribution
GO
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
-- Get the publication name based on article --
p.publication publication_name , a.article , a.destination_object ,
ss.srvname subscription_server , s.subscriber_db ,
da.name AS distribution_agent_job_name FROM
MSArticles a
JOIN
MSpublications p ON a.publication_id = p.publication_id
JOIN
MSsubscriptions s ON p.publication_id = s.publication_id
JOIN
master..sysservers ss ON s.subscriber_id = ss.srvid
JOIN
master..sysservers srv ON srv.srvid = p.publisher_id
JOIN
MSdistribution_agents da ON da.publisher_id = p.publisher_id
AND da.subscriber_id = s.subscriber_id
ORDER BY 1,2,3
