If you are not completely clear on how the behavior of schemas changed in SQL Server 2005, or the implications of the separation of ownership from schemas, here’s a quick, concise summation on the subject from MSDN Library that should clear things up. Note that in this usage we are referring to database Schemas, not XML schemas. The article covers topics like object ownership changes, system tables replaced with catalog views and functions, default schemas, schemas catalog views and functions and other topics as well.
By the way, you might also be interested in Digital Media Minute’s own script on printing SQL Server Database Schema, by Jim Rutherford.
