EnumPublicationReferences Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The EnumPublicationReferences method returns a QueryResults object that enumerates dependency relationships for database objects published as articles.
Syntax
object
.EnumPublicationReferences( )
as
QueryResults
Parts
- object
Expression that evaluates to an object in the Applies To list
Prototype (C/C++)
HRESULT EnumPublicationReferences(
LPSQLDMOQUERYRESULTS* ppResults);
Returns
A QueryResults object that contains 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 |
|---|---|---|
ArticleObject |
nvarchar(129) |
Name of article publishing referenced data. |
ReferencingObject |
nvarchar(129) |
Name of database object referencing publication 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 |
|---|---|---|
ArticleObject |
nvarchar(129) |
Name of article publishing referencing data. |
ReferencedObject |
nvarchar(129) |
Name of database object referenced and not published. |
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.