You can use the sp_helpprimaryconn procedure to get a list of all unpublished objects in a primary database. Unpublished objects in a primary database are objects for which no primary articles exist.
To get information about all unpublished
primary objects in a specific primary database
Use sp_helpprimaryconn with the unpub keyword, and specify a primary database connection:
sp_helpprimaryconn unpub, conn="conn_name"
where conn_name is the name of a primary database connection.
