IHpublishers (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The IHpublishers system table contains one row for each non-SQL Server Publisher using the current Distributor. This table is stored in the distribution database.


Column name Data type Description
publisher_id smallint Identifies a non-SQL Server Publisher.
vendor sysname The name of the vendor for the non-SQL Server database.
publisher_guid uniqueidentifier A GUID that identifies the non-SQL Server Publisher.
flush_request_time datetime Indicates the date and time when the last change occurred to article metadata that required the Log Reader Agent to update its metadata cache.
version sysname A text string that characterizes the version of the non-SQL Server Publisher.

See Also

Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sp_adddistpublisher (Transact-SQL)
sp_changedistpublisher (Transact-SQL)
sp_helpdistpublisher (Transact-SQL)