I have to get list of allt he articles freom different databases/servers. Store the list in a table and then get record counts of each article from subscribersr and then publishers.
replsevers table has these records.
SELECT * FROM [server1].database1.dbo.Sysarticles
SELECT * FROM [server2].database2.dbo.Sysarticles
SELECT * FROM [server3].database3.dbo.Sysarticles
I have to execute these selects and store their output to a table. Then get each article and their record count from subscriber and publisher.
I have created a table listing subscirbers and publishers information.
Can anyone suggest me how to resolve my problem?