title: Unable to drop constraint in SQL server 2005, "Could not drop constraint. See previous errors"
body: <p>I'm trying to drop a constraint on a DB table, something like:
  </p>
  
  <pre><code>ALTER TABLE MyTable drop CONSTRAINT FK_MyTable_AnotherTable
  </code></pre>
  
  <p>But the execution just runs and runs. If I stop it I see:</p>
  
  <pre><code>Msg 3727, Level 16, State 0, Line 2
  Could not drop constraint. See previous errors.
  </code></pre>
  
  <p>Web search throws up various pages but note that the constraint is properly named and I am trying to remove it using the correct name</p>