What would happen, if the current user is mapped to any one of the two schema's by default? Last statement would always throw an error!!
As this option was not one of the choice, I marked all three statements will execute successfully.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter