title: Cannot drop the distribution database 'distribution' on managed instance
body: <p>I am not able to delete the distributor and distribution database because it is saying that it is currently in use on Azure Managed Instance.I tried transactional replication between azure managed instance to azure sql vm. Then I was trying to delete replication ,publisher,subscriber and distributor.I was successful in dropping replication,publisher and subscriber but my distributor is not getting deleted.
  I am trying to do:</p>
  
  <p><code>exec sp_dropdistributor @no_checks = 1, @ignore_distributor = 1</code></p>
  
  <p>Then I got this below statement as error:</p>
  
  <blockquote>
    <p>Msg 21122, Level 16, State 1, Procedure sys.sp_dropdistributiondb,
    Line 125 [Batch Start Line 6]</p>
    
    <p>Cannot drop the distribution database 'distribution' because it is
    currently in use.</p>
  </blockquote>
  
  <p>I even tried to disable distributor using Disable publishing and distributor wizard.The process was unsuccessful.
  What steps should I now follow to delete my distributor?</p>