IHpublishers (Transact-SQL)

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

Reference

Replication Views (Transact-SQL)
sp_adddistpublisher (Transact-SQL)
sp_changedistpublisher (Transact-SQL)
sp_helpdistpublisher (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)

Other Resources

Heterogeneous Database Replication

Help and Information

Getting SQL Server 2005 Assistance