ihpublishers-transact-sql.md

title	IHpublishers (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	IHpublishers IHpublishers_TSQL
dev_langs	TSQL
helpviewer_keywords	IHpublishers system table
ms.assetid	77007246-f10b-4b87-8edf-7afc3c2096af
author	stevestein
ms.author	sstein

IHpublishers (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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.

Definition

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)