We've upgraded our database from 2000 to 2008 (using this method in case it's important: http://msdn.microsoft.com/en-us/library/ms189625.aspx
We are now testing this and are having a problem with resolving table names from our .NET website. Using Enterprise Mgr I've verified that the tables are there. Plus if I use the schema/owner name and the table name it works.
"select *, C.ClientName FROM portal.UserTable U"
For the user I'm using to connect to the database the default schema is set to 'portal' when I check that user's properties, but that doesn't seem to make a difference.
Our system is full of non-fully qualified names, so I would really like to figure out how to get the default to work so I don't have to go through the entire system and make changes to the table names in the queries.
Thanks for the help.