I am working on an application that will be used to compare databases on several servers. I need to compare tables, views, stored procedures, functions and triggers, but only those used for replication. Comparing tables is pretty easy, as sysmergearticles table contains objects with ids of every table used for replication, but it does not contain data about functions, stored procedures and views (all records in sysmergearticles have type = 10, which indicates that it's a table object). Where can I find data about them?
Thank you for your reply, but that's not exactly what I am looking for. All data on the objects are in the sysobjects table, eg. for stored procedures:
select * from sysobjects where xtype = 'P' and category <> 2
which returns all user-defined stored procedures. I just need to determine which of those are replicated. I also tried looking in sysmergeschemaarticles, which contains most of user-defined procedures, functions and views, but not all of them are displayed.