[RESOLVED] I need help with default schema

[MrNorth]

Hi!

A user is complaining about a database I have set up. The setup is like this:

I created a database A

I created a login Donald
I created a user Donald

The user Donald has Donald as the default schema. So in database A all tables looks like this

Donald.TableA
Donald.TableB
...

The login Donald is connected to the database A, user Donald and default schema Donald.

The problem is that when the user log on , he must write

select * from Donald.TableA Where.....

He wants to write select * from TableA..


I am rather new to SQL Server 2005, what have I missed here? I am using Management Studio..

The connection stirng looks like this:
Provider=SQLNCLI;Server=.\SQLEXPRESS;Database=A;User ID=Donald;Password=pass;Default Schema=Donald"

kind regards
Henrik