|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
27/09/2007, 15h44
|
#1 |
Messages: n/a
Hébergeur: |
Set default schema in code - possible?
==SQL Server 2005 SP2==
Is it possible to set the default schema in code? I know that, for a particular DB user, I can set the default schema statically in Mgmt Studio. However, I want to do this dynamically in source code. I am using JDBC if that matters. Any appreciated. TIA aj |
|
|
27/09/2007, 23h46
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Set default schema in code - possible?
aj (ronald@mcdonalds.com) writes:
> Is it possible to set the default schema in code? > > I know that, for a particular DB user, I can set the default schema > statically in Mgmt Studio. However, I want to do this dynamically > in source code. You can change the default schema for a user with ALTER USER. Look in Books Online for details. Or use the Script button in SSMS to see how Mgmt Studio do it. Whether it is a good idea is another matter. If you are writing an admin application, I guess it's OK. But if you are considering changing the schema of the current user on the fly, keep in mind that it will affect all sessions for that user. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
|
|
|
| Outils de la discussion | |
|
|
