Here is my blog post at the ISV Team blog. DEFAULT_SCHEMA setting helped in a number of cases, especially with legacy code. It could help you if have upgraded from an earlier version of SQL Server and you are not parameterizing your trivial queries. http://blogs.msdn.com/mssqlisv/archive/2007/03/23/upgrading-to-sql-server-2005-and-default-schema-setting.aspx

-Cihan