title: How do I change the owner of a SQL Server database?
body: <p>When I accidentally click on the Database Diagrams tab, I get one of the following errors:</p>
  
  <blockquote>
    <p>Database diagram support objects
    cannot be installed because this
    database does not have a valid owner.
    To continue, first use the Files page
    of the Database Properties dialog box
    or the ALTER AUTHORIZATION statement
    to set the database owner to a valid
    login, then add the database diagram
    support objects.</p>
  </blockquote>
  
  <p>--- or ---</p>
  
  <blockquote>
    <p>The database does not have one or more
    of the support objects required to use
    database diagramming. Do you wish to
    create them?</p>
  </blockquote>
  
  <p>What's the syntax for changing the owner of this database to 'sa'?</p>