SQL Server 2008 Unable to resolve table names

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.

This 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.
Who is Participating?
JoeNuvoConnect With a Mentor Commented:
you might need to consider change the table schema to be 'dbo' instead of 'Portal'

Ryan McCauleyData and Analytics ManagerCommented:
What's the exact error you receive when you "can't resolve the name" - something like "object does not exist"? The exact message will help the troubleshooting immensely.
hzuker44Author Commented:
When I execute the query:

    "select * FROM UserTable U"

The resulting error message is:

    Invalid object name 'UserTable'.
hzuker44Author Commented:
Well this solution works for us.  But it would still be nice to know why the default schmea setting didn't worked.

hzuker44Author Commented:
It solved the problem.  It did work around our issue so we didn't have to fix the source of the problem.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.