by mistake I added an queue reader agent to a distribution database. But how can I drop the queue agent. There isn't a stored proc 'sp_dropqreader_agent'.
The only way I found (apart from dropping the whole distribution databse) is to stop and disable the generated job!
Is there any other way to get rid of the queue reader agent ?
WolfgangOnly supported way I know of is to run sp_dropdistributiondb. I haven't tested this, but as dbo or 'sa', maybe you can manually delete the job?|||Dropping the distributiondb will of course solve the problem, but it is not a good idea if there is a active replication.
I tested deleting the job yesterday and it seems that it works. But I don't know if there are side effects or not. So I prefer an offical way, for example an system procedure sp_dropqreader!
Wolfgang|||if you are not using queue updatable subscriptions, then manually dropping the job should work just fine.|||But I just found that sp_addqreaderagent generates proxy accounts and credentials as well. And these objects are not dropped automatically. I need to drop them manually! Are there more objects created by sp_addqreaderagent ? I don't know. That are more reasons for me to have a procedure to drop queue reader agents!
Wolfgang
No comments:
Post a Comment