Re: sql 2005 schema as the default schema.
- From: "Jasper Smith" <jasper_smith9@xxxxxxxxxxx>
- Date: Fri, 25 Nov 2005 00:16:33 -0000
You can set this as the property of a database user e.g.
alter user foo with default_schema=bar
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Nalaka" <nalaka12@xxxxxxxxxxxxx> wrote in message
news:%236rsiHV8FHA.3388@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
> is it possible to set a "connection string" to use a default schema.
> instead of me having to prefix tablename with schema name in the query.
>
> so, if I don't say a schema name it uses the default schema (not .dbo).
>
>
>
>
> Thanks
> Nalaka
>
>
.
- References:
- sql 2005 schema as the default schema.
- From: Nalaka
- sql 2005 schema as the default schema.
- Prev by Date: sql 2005 schema as the default schema.
- Next by Date: [ANNOUNCE] Announcing NOOFS 0.8 Release Candidate
- Previous by thread: sql 2005 schema as the default schema.
- Next by thread: [ANNOUNCE] Announcing NOOFS 0.8 Release Candidate
- Index(es):
Relevant Pages
|
