Posted by Gregor Stefka on 01/09/06 11:09

athos schrieb:
> Hi guys, please help.

> ALTER USER kimliuTest WITH DEFAULT_SCHEMA = schTest
>
> to set the default schema.
>
> Now my problem is, when I try to run
>
> select * from schTest.t2
>
> , everything is OK, but if I run
>
> select * from t2
>
> the error message says:
>
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 't2'.
>
> why? I'm loggin in with my [kkhad\kimliu] windows domain id , Active
> Monitor also shows that. but the command does not work?

Please refer to the BOL on CREATE USER / ALTER USER.
There are some restrictions on how DEFAULT_SCHEMA can be used:

http://msdn2.microsoft.com/en-US/ms173463.aspx


hth
Stefka

• Next in forum: Re: How to omit Schema name when referrring to Tables?
• Prev in forum: Re: Combining 3 SQL statements
• Thread view: Re: How to omit Schema name when referrring to Tables?

[Reply to this message]