PHWinfo - Afficher un message - Set default schema in code

27/09/2007, 15h44

==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, 15h44	#1
aj 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