IHpublishers (Transact-SQL)


Applies To: SQL Server

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 nameData typeDescription
publisher_idsmallintIdentifies a non-SQL Server Publisher.
vendorsysnameThe name of the vendor for the non-SQL Server database.
publisher_guiduniqueidentifierA GUID that identifies the non-SQL Server Publisher.
flush_request_timedatetimeIndicates the date and time when the last change occurred to article metadata that required the Log Reader Agent to update its metadata cache.
versionsysnameA text string that characterizes the version of the non-SQL Server Publisher.

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

Community Additions