I guess problems with schema started when ms introduced a "everyone" schema : DBO.

Making a "transparant" option is a terrific way to mistify objects.

Backside of this implementation is (of course) the ownership-chaining-struggle.

Because they did implement authority at db-level (e.g. db-datareader) and did not implement

schema-based authority (grant to schema1) it's an all or struggle option.

This combined with the fact that in some cases only dbo-objects are supported with upgrades

(did they forget about schema (i.e.bug) or was this the intention ? I had a couple of non-dbo tables that were replicated and gave me a couple of headaches when

I upgraded that server from sql7 to sql2k.)

Maybe the time to rollback the dbo-concept is nolonger an option and we all are asking ourselves what the use of schema is becaus it gives us so much troubles.

Thank you transparacy.