Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_helplogreader_agent (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_helplogreader_agent (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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 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.

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.

Community Additions

ADD
Show:
© 2015 Microsoft