Here it is 2012 already and I am just starting to play with schemas in SQL 2005. Anyway, follow the directions below to just start using a Schema as a container or namespace for your objects. Create a Role “schema_owner” and set the owner to dbo. Create schema “myschema” and set the owner to “schema_owner”. I personally used the same… Read more →