title: Dropping a DDL Trigger gives error
body: <p>I created a simple trigger using the below code</p>
  
  <pre><code>Create Trigger preventDrop on Database for Drop_Table   
  AS
      Print 'You cannot Drop a Table'
      RollBack;
  Go
  </code></pre>
  
  <p>And It works Ok. It does not let me drop a Table. But Now When I drop this trigger using </p>
  
  <pre><code>drop Trigger preventDrop
  </code></pre>
  
  <p>It does not let me drop the trigger and gives the following error</p>
  
  <pre><code>Msg 3701, Level 11, State 5, Line 10
  Cannot drop the trigger 'preventDrop', because it does not exist or you do not have permission.
  </code></pre>
  
  <p>What could be the problem?</p>