We just copied a SQL 2008 database over to another server, for testing purposes. The typical user that logs in uses some objects in a certain schema. Let's say it's user
foo and schema
foo's default schema is
bar at both the instance and database level. However, when
foo logs in it can't find any objects in the
bar schema without using a fully qualified name.
Why wouldn't the default schema work here?