Query to find non-replicated objects

• bridgt01

  SSCommitted

  Points: 1890

  More actions

  January 9, 2012 at 3:09 pm

  #249308

  I've searched a little but haven't found anything worthwhile. Does anyone have a query to find all user objects within a database that aren't affiliated with a publication? This is a merge replication environment.

• bridgt01

  SSCommitted

  Points: 1890

  More actions

  January 9, 2012 at 8:22 pm

  #1430879

  I think I found what I was looking for. The query below gives a good indication of what isn't being replicated:

  SELECT * FROM sys.objects so

  WHERE object_id NOT IN (SELECT objid FROM sysmergearticles)

  AND type IN ('U', 'V', 'P')

  AND is_ms_shipped <> 1

  ORDER BY type, name