title: How to drop a SQL Server user with db owner privilege
body: <p>I need to drop a user with <code>dbowner</code> schema from a SQL Server database. I cannot drop it as it is since I get this error message</p>
  <blockquote>
  <p>Drop failed for User 'network service'.  (Microsoft.SqlServer.Smo)</p>
  <p>The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)</p>
  </blockquote>
  <p>When I try to uncheck the schema owned by this user to remove the DB owner it does nothing. My question is how I can drop this user or edit its name from <code>'network service' to 'NT AUTHORITY\NETWORK SERVICE'</code></p>