Re: Display my default schema?

From: "Rubén Garrigós" <rgarrigos@xxxxxxxxxx>
Date: Fri, 18 Apr 2008 01:25:46 +0200

Try this:

select default_schema_name from sys.database_principals where
name=USER_NAME()

--
Rubén Garrigós
Solid Quality Mentors

"David Walker" <none@xxxxxxxx> wrote in message
news:Xns9A8385FF64E70DavidWalker@xxxxxxxxxxxxxxxx

How do I display the default schema that is assigned to me (the user with
which I am connected to SQL Server 2005/2008)?

David Walker

Follow-Ups:
- Re: Display my default schema?
  - From: David Walker

References:
- Display my default schema?
  - From: David Walker

Prev by Date: Re: Migration from existing database server 2005 to new database server 2005
Next by Date: Re: Display my default schema?
Previous by thread: Display my default schema?
Next by thread: Re: Display my default schema?
Index(es):
- Date
- Thread