asked on

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.

Ryan McCauley

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.

hzuker44

ASKER

When I execute the query:

"select * FROM UserTable U"

The resulting error message is:

Invalid object name 'UserTable'.

ASKER CERTIFIED SOLUTION

JoeNuvo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hzuker44

ASKER

Well this solution works for us. But it would still be nice to know why the default schmea setting didn't worked.

Thanks

hzuker44

ASKER

It solved the problem. It did work around our issue so we didn't have to fix the source of the problem.