Just to float an idea,
What if the Use command could also specify a default schema for that session? It wouldn't be as permanent as setting the user's default schema.
would change database and set the default schema to Production for that session.
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Paul Nielsen
Paul Nielsen believes SQL is the romance language of data. As such he’s a hands-on database developer, Microsoft SQL Server MVP, trainer, and author of SQL Server Bible series (Wiley). As a data architect, he developed the concepts of Smart Database Design and Nordic – an open source O/R dbms for SQL Server. He lives in Colorado Springs.