Getting information about unpublished objects

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.