Completely disable SQL replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Completely disable SQL replication

I have several SQL servers that do not have any Publications configured. However, there are users (aliased DBO’s) that are configuring Transactional replication jobs to pull from these servers. References to these jobs show up under Replication -> Subscriptions. I want to disallow this from happening. DTS jobs are fine, but no replication. Is there anything I can do to disable this replication from being configured? Thanks, Tom
revoke access to the sp_addpublication, sp_addarticle, etc. from the users who are causing the ‘problems’ These are in the master database so they shouldn’t be dbos in that database Cheers
Twan
To remove replication you can use SP_REMOVEDBREPLICATION. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>