title: Schema, Owner for objects in MS SQL
body: <p>By default, objects (tables, stored procedures, etc) are set up with the dbo owner/schema (I think ms sql 2000 calls it owner, while ms sql 2005 calls it schema)</p>
  
  <p>The owner/schema is really a role or user in the database.  I've always left the default of dbo, but I've recently seen some examples in microsoft training books where some of their tables &amp; stored procedures had different owners/schemas.  When is it beneficial to do this and why?</p>