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

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

Changes security properties of a Queue Reader agent. This stored procedure is executed at the Distributor on the distribution database or at the Publisher on the publication database.

Topic link icon Transact-SQL Syntax Conventions

sp_changeqreader_agent [ [ @job_login = ] 'job_login' ]
    [ , [ @job_password = ] 'job_password' ]
    [ , [ @frompublisher = ] frompublisher

[ @job_login= ] 'job_login'

Is the login for the Microsoft Windows account under which the agent runs. job_login is nvarchar(257), with a default of NULL.

[ @job_password= ] 'job_password'

Is the password for the Windows account under which the agent runs. job_password is sysname, with a default of NULL.

[ @frompublisher= ] frompublisher

Is if the procedure is being executed at the Publisher. frompublisher is bit, with a default value of 0. A value of 1 means that the procedure is being executed from the Publisher on the publication database.

0 (success) or 1 (failure)

sp_changeqreader_agent is used in transactional replication.

sp_changeqreader_agent is used to change the Windows account under which a Queue Reader agent runs. You can change the password of an existing Windows login or supply a new Windows login and password.

After changing an agent login or password, you must stop and restart the agent before the change takes effect.

Only members of the sysadmin fixed server role can execute sp_changeqreader_agent.

Community Additions

ADD
Show:
© 2015 Microsoft