EnumPublicationReferences Method (SQL-DMO)

The EnumPublicationReferences method returns a QueryResults object enumerating dependency relationships for database objects published as articles.

Applies To

MergePublication Object

Syntax

object.EnumPublicationReferences() as QueryResults

Part Description
object Expression that evaluates to an object in the Applies To list

Returns

A QueryResults object containing two result sets. The first result set enumerates objects outside the publication that depend on data published by the article, and is defined by these columns.

Column Data type Description
ReferencingObject nvarchar(129) Name of database object referencing publication data
ArticleObject nvarchar(129) Name of article publishing referenced data

The second result set enumerates database objects not published by the publication and on which an article in the publication depends.

Column Data type Description
ReferencedObject nvarchar(129) Name of database object referenced and not published
ArticleObject nvarchar(129) Name of article publishing referencing data

Remarks

The result sets of the QueryResults object contain rows when dependencies exist in the replication database and those dependencies are not reflected in the publication.

Prototype (C/C++)

HRESULT EnumPublicationReferences(
LPSQLDMOQUERYRESULTS* ppResults);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.