This could simplify the interface for loading data into mssql databases. But schema wouldn't be used by the BCP command line utility, so it could be misleading. Setting at the connection level may lead a user to think that the provided query does not need a two/three part name when they are not querying the default schema.
This could simplify the interface for loading data into mssql databases. But schema wouldn't be used by the BCP command line utility, so it could be misleading. Setting at the connection level may lead a user to think that the provided query does not need a two/three part name when they are not querying the default schema.