Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. https://blogs.msdn.com/mssqlisv/archive/2007/03/23/upgrading-to-sql-server-2005-and-default-schema-setting.aspx
-Cihan