I have to disagree with you. When using a script, it's your responsibility to make it work not SQL Server.

>When doing it from the interface, SQL Server does the switch automatically. From the script, it would be nice if it would do the same as well.