title: Cannot drop/alter tables due to transaction ended in trigger error ms-sql-server 2008
body: <p>I cannot alter/drop any objects in my database, only create, insert, and delete records. For instance, I'm getting...</p>
  
  <p>You can not
  Msg 3609, Level 16, State 2, Line 1
  The transaction ended in the trigger. The batch has been aborted.</p>
  
  <p>on the following code (on the drop table step):</p>
  
  <pre><code>create schema Test
  go
  create table test.test (
  test varchar(5) 
  )
  go
  insert into test.test(test) values('test')
  go
  select *
  from Test.test
  go
  drop table Test.test
  go
  drop schema Test
  go
  </code></pre>
  
  <p>I have definitely not created any triggers on the database EVER. I do not have control of the server so my permissions are limited. The problem just occurred. I have been using this database for years. This is the first time this has happened. I believe it has something to do with permissions.</p>
  
  <p>I have no idea what is causing this new error to occur.</p>