"Zhou Xiang" <ZhouXiang@discussions.microsoft.com> wrote in message
news:C37399D9-0312-47B8-95CA-91023A18055F@microsoft.com...
> In the database(SQL Server 2005), I want to get the DEFAULT_SCHEMA for the
> Login(or a user), how I can get it easily?
>
> Thanks.

"Uri Dimant" wrote:

> Hi
> CREATE LOGIN res WITH password='pp'
>
> CREATE USER res FOR LOGIN res
>
> SELECT * FROM sys.database_principals WHERE name ='res'
>
>
>
>
>
>
>
> "Zhou Xiang" <ZhouXiang@discussions.microsoft.com> wrote in message
> news:C37399D9-0312-47B8-95CA-91023A18055F@microsoft.com...
> > In the database(SQL Server 2005), I want to get the DEFAULT_SCHEMA for the
> > Login(or a user), how I can get it easily?
> >
> > Thanks.
>
>