EnumPublicationReferences Method
Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The EnumPublicationReferences method returns a QueryResults object that enumerates dependency relationships for database objects published as articles.
Sintassi
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. |
Osservazioni
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.