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