April 27, 2011 at 4:47 am
I find the following error when I am trying to setup the transactional Replication from Previously generated script.
ERROR: " Msg 21831, Level 16, State 1, Procedure sp_addqreader_agent, Line 147
The qreader agent already exists. Use 'sp_changeqreader_agent' to change any settings/properties."
April 28, 2011 at 2:06 pm
Ignore it. The Queue Reader job must already exist on this instance. You only need one.
April 28, 2011 at 10:58 pm
http://msdn.microsoft.com/en-us/library/ms189532.aspx
http://msdn.microsoft.com/en-us/library/ms147827(v=sql.90).aspx
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 29, 2011 at 6:04 am
Thanks..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply