Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Returns properties of the Log Reader Agent job for the publication database. This stored procedure is executed at the Publisher on the publication database.
Transact-SQL syntax conventions
Syntax
sp_helplogreader_agent [ [ @publisher = ] N'publisher' ]
[ ; ]
Arguments
[ @publisher = ] N'publisher'
The name of the Publisher. @publisher is sysname, with a default of NULL. This parameter is for non-SQL Server Publishers only. The value of this parameter must be NULL for a SQL Server Publisher.
Result set
| 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 values:0 = SQL Server Authentication1 = 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).
Remarks
sp_helplogreader_agent is used in transactional replication.
Permissions
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.