title: SQL server 2012: failed to change Database owner
body: <p>The original owner of the Database has left the company, so I want to change the owner to myself, however, it failed.<br>
  When I tried through SSMS: Database properties->Files->Owner, it give the error message like:  </p>
  
  <blockquote>
    <p>Set owner failed for Database XYZ.<br>
    An exception occurred while executing a Transact-SQL statement or batch.<br>
    Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)</p>
  </blockquote>
  
  <p>And when I tried through script with the query:   </p>
  
  <blockquote>
    <p>ALTER AUTHORIZATION ON DATABASE::XYZ TO [MyUserName]  </p>
  </blockquote>
  
  <p>The query seems blocked and run forever without success.<br>
  Can anybody give some help?</p>