I have 15 database some of which are replicated.
Sometimes the replication on all clustered indexesfor all tables of one of my replication change its value to False.
I'd like to know if there is a way in TSQL to make a query that'll check this properties for all articles of all replications on my server.
i tried to get the list of all the replications with
exec sp_msforeachDB 'Select ''?'' as dbname,name From ?..SysPublications'
But this raise an error if there is no replication in one database.
