sp_helplogreader_agent (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Returns properties of the Log Reader Agent job for the publication database. This stored procedure is executed at the Publisher on the publication database.

Topic link icon Transact-SQL Syntax Conventions


sp_helplogreader_agent [ [ @publisher = ] 'publisher' ]  


[ @publisher = ] 'publisher' Is the name of the Publisher. publisher is sysname, with a default of NULL.

Result Sets

Column name Data type Description
id int ID of the agent.
name nvarchar(100) Name of the agent.
publisher_security_mode smallint Security mode used by the agent when connecting to the Publisher, which can be one of the following:

0 = SQL Server Authentication

1 = Windows Authentication.
publisher_login sysname Login used when connecting to the Publisher.
publisher_password nvarchar(524) For security reasons, a value of ********** is always returned.
job_id uniqueidentifier Unique ID of the agent job.
job_login nvarchar(512) Is the Windows account under which the Log Reader Agent runs, which is returned in the format domain\username.
job_password sysname For security reasons, a value of ********** is always returned.

Return Code Values

0 (success) or 1 (failure)


sp_helplogreader_agent is used in transactional replication.


Only members of the sysadmin fixed server role at the Publisher or members of the db_owner fixed database role on the publication database can execute sp_helplogreader_agent.

See Also

View and Modify Replication Security Settings
sp_addlogreader_agent (Transact-SQL)
sp_changelogreader_agent (Transact-SQL)