sp_helplogreader_agent (Transact-SQL)


THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure 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.

Column nameData typeDescription
idintID of the agent.
namenvarchar(100)Name of the agent.
publisher_security_modesmallintSecurity 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_loginsysnameLogin used when connecting to the Publisher.
publisher_passwordnvarchar(524)For security reasons, a value of ********** is always returned.
job_iduniqueidentifierUnique ID of the agent job.
job_loginnvarchar(512)Is the Windows account under which the Log Reader Agent runs, which is returned in the format domain\username.
job_passwordsysnameFor security reasons, a value of ********** is always returned.

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.

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

Community Additions