Problem In Assigning Default Schema To Database User ?

[santhanalakshmi]

Dear All,

I am using SQL Server 2008, I have setup a login user "User1" and next I setup database user using the same user name and login name. After that I create a new schema "mySchema" and make "User1" as the owner of the schema. To "User1" I assigned the default schema to "mySchema", so far its working fine. But when I open the user's property window (dialog box) the default schema always gets reset to "dbo".

What could be the problem here? Please help me if there is any solution to get the right schema which I assigned to the user.


Thanks and regards,