Ed Wagner (3/12/2013)
The dbo schema first, then default. Thank you, Lowell. I just learned something.
Actually, if you do not provide the schema for the object it will look first in the users default schema, then it will look in the dbo schema.
I just tested this myself.