Originally posted by: Dan W
Question I'm puzzled by:
It make it feasible to use something other than dbo for the third part of a four-part name. I still haven't really used a schema other than dbo, but I think I just might use the dbo schema it as a way to grant execute permissions to my stored procedures.
Actually I discussed this with Microsoft execs at the introductory festivities in November 2005, Las Vegas, Mandalay Bay Hotel Casino. Having a single level schema is very limiting, not much help in a large database e.g. 3000 tables.
You would need multi-level schema to properly organize your tables and other database objects in large environment.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/