Possible to set default schema from connection string?

Question

With SQL Server 2005 and 2008 is it possible to set the default schema from the connection string? It'd be a lot easier if we didn't have to manually set the schema with SQL code.

Answer 1

You set the default schema based on the user who is logging in via the connection, not the connection itself.

ALTER USER Mary51 WITH DEFAULT_SCHEMA = Purchasing;

Reference:

• ALTER USER

Answer 2

change the default schema associated with that login

example

ALTER USER Mary51 WITH DEFAULT_SCHEMA = Purchasing;

More detail here: http://msdn.microsoft.com/en-us/library/ms176060.aspx

Answer 3

No, this is done at the database User level, not in the connection string.

For reference, here are all of the properties which can be set in a connection string: http://www.connectionstrings.com/Articles/Show/all-sql-server-connection-string-keywords