469,085 Members | 1,004 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,085 developers. It's quick & easy.

Problem In Assigning Default Schema To Database User ?

147 100+
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,
Oct 25 '10 #1
0 1048

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Hemant Shah | last post: by
7 posts views Thread by greatcanyon | last post: by
1 post views Thread by Nalaka | last post: by
4 posts views Thread by bea | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.