SQL Server Performance

Completely disable SQL replication

Discussion in 'Performance Tuning for SQL Server Replication' started by tdrsqlperf, Sep 18, 2003.

  1. tdrsqlperf New Member

    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
  2. Twan New Member

    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
  3. satya Moderator

    To remove replication you can use SP_REMOVEDBREPLICATION.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page