Posted by aj on 09/27/07 13:44

==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 help appreciated.

TIA

aj

• Next in forum: Select Into across Linked Servers
• Prev in forum: Re: find unique identifier through multiple tables
• Thread view: Set default schema in code - possible?

[Reply to this message]